Databases Reference
In-Depth Information
The Table View
A slightly different box is available in the Table view from the
SQL
menu.
The lower part has bookmark-related choices (explained in Chapter 14). There is
also a
Fields
selector and an
Insert
button on the right. The box already has a
default query.
This query
SELECT
*
FROM
'books'
WHERE
1
is generated from the
$cfg['DefaultQu
eryTable']
configuration directive, which contains
SELECT
*
FROM
%t
WHERE
1
. Here,
the
%t
is replaced by the current table name. Another placeholder available in
$cfg
['DefaultQueryTable']
is
%f
, which would be replaced by the complete field list
of this table, thus producing the query:
SELECT
'isbn',
'title',
'page_count',
'author_id',
'language',
'description',
'cover_photo',
'genre'
FROM
'books'
WHERE
1
.
Search WWH ::
Custom Search