Database Reference
In-Depth Information
Another case is that of the backquotes. If we just click on
Browse
for the topic table,
phpMyAdmin generates
SELECT
*
FROM
`book`
, enclosing the table name with
backquotes. This is MySQL's way of protecting identifiers, which might contain
special characters, such as spaces, international characters, or reserved words.
However, sending this query to the Validator shows us that the backquotes do not
conform to standard SQL. We may even get two errors, one for each backquote.
Summary
This chapter helps us understand the purpose of query boxes and shows us
where to find them. It also gives us an overview of the Query window options,
multi-statement queries, how to use the field selector, how to use the SQL Validator,
and finally, how to get a history of the typed commands. The next chapter will show
how to produce multi-table queries without typing, thanks to phpMyAdmin's
query generator.
Search WWH ::
Custom Search