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...