In PHP and MySQL programming, we can send only one query at a time using the
mysql_query() function call. phpMyAdmin allows us to send 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
Let's send the same list of queries again and ...