Databases Reference
In-Depth Information
Another case is that of the backquotes. If we just click on
Browse
for thebooks
table, phpMyAdmin generates
select
*
from
'books'
, enclosing the table name
with backquotes. This is the MySQL way of protecting identifiers, which might
contain special characters, like spaces or international characters, or reserved words.
However, sending this query to the Validator shows us that the backquotes do not
conform to standard SQL. We even get two errors - one for each backquote:
Summary
In this chapter, we took a look at the purpose of query boxes and where they can be
found. We also looked at query window options, multi-statement queries, how to
use the field selector, how to use the SQL Validator, how to get a history of the typed
commands, and how to handle views.
Search WWH ::
Custom Search