This happens because of the default setting for this parameter:
$cfg['EditInWindow'] = TRUE;
When it is set to FALSE, a click on Edit would not open the query window; instead,
the query would appear inside the query box of the SQL sub-page.
Multi-Statement Queries
In PHP/MySQL programming, we can only send one query at a time using the
mysql_query() function call. phpMyAdmin allows for sending many queries in one
transmission, using a semicolon as a separator. Suppose we type the following query
in the query box:
INSERT INTO author VALUES (100,'Paul Smith','111-2222');
INSERT INTO author VALUES (101,'Melanie Smith','222-3333');
UPDATE author SET phone='444-5555' WHERE name LIKE '%Smith%';
We will receive the following results screen:
We see the number of affected rows through comments because $cfg['VerboseMult
iSubmit'] is set to TRUE.
Chapter 12
[ 201 ]
Let's send the same list of queries again and watch the results:
It is normal to receive a Duplicate entry error: the value 100 already exists. In version
2.11.0, a Browse button permits to display the existing entry; however, this feature
was sometimes misbehaving, depending on the key value, so the Browse
button no longer appears starting from version 2.11.1.
We are seeing the results of the first INSERT statement, but what happens to the
next one? Execution stops at the first error because $cfg['IgnoreMultiSubmit
Errors'] is set to FALSE, telling phpMyAdmin not to ignore errors in multiple
statements.
Pages:
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196