-
Book Overview & Buying
-
Table Of Contents
Mastering phpMyAdmin 2.11 for Effective MySQL Management - Third Edition
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['VerboseMultiSubmit'] is set to TRUE.
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...
Change the font size
Change margin width
Change background colour