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