Databases Reference
In-Depth Information
The Table view
A slightly different box is available in the
Table
view of the
book
table from the
SQL
menu.
The box already has a default query as seen in the previous screenshot. This
default query is generated from the
$cfg['DefaultQueryTable']
configuration
directive, which contains
SELECT
*
FROM
@TABLE@
WHERE
1
. Here, the
@TABLE@
is replaced by the current table name. Another placeholder available in
$cfg['DefaultQueryTable']
is
@FIELDS@
. This placeholder would be replaced by
the complete column's list of this table, thus producing the following query:
SELECT `isbn`, `title`, `page_count`, `author_id`, `language`,
`description`, `cover_photo`, `genre`, `date_published`, `stamp`,
`some_bits` FROM `book` WHERE 1.
WHERE
1
is a condition that is always true. Therefore, the query can be executed as
it is. We can replace
1
with the condition we want, or we can type a completely
different query.
Search WWH ::
Custom Search