Databases Reference
In-Depth Information
Because this SQL box appears in the Table view, the table name is known; therefore,
phpMyAdmin shows buttons below the query box, which permit to quickly create
common SQL queries which contain this table name. Most of the queries generated
by these buttons contain the full column list.
The Columns selector
The Columns selector is a way to speed up query generation. By choosing a column
and clicking on the arrows << , this column name is copied at the current cursor
position in the query box. Here, we select the author_id column, remove the digit 1 ,
and click on << . Then we add the condition = 2 as shown in the following screenshot:
The Show this query here again option (checked by default) ensures that the query
stays in the box after its execution if we are still on the same page. This can be seen
more easily for a query like an UPDATE or DELETE , which affects a table, but does not
produce a separate results page.
Clicking into the query box
We might want to change the behavior of a click inside the query box with the
$cfg['TextareaAutoSelect'] configuration directive. Its default value is FALSE ,
which means that no automatic selection of the contents is done upon a click. Should
you change this directive to TRUE , the first click inside this box will select all its
contents. (This is a way to quickly copy the contents elsewhere or delete them from
the box.) The next click would put the cursor at the click position.
 
Search WWH ::




Custom Search