Databases Reference
In-Depth Information
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. But what
happens to the next
INSERT
statement? Execution stops at the first error because
$cfg['IgnoreMultiSubmitErrors']
is set to
FALSE
, telling phpMyAdmin not to
ignore errors in multiple statements. If it is set to
TRUE
, the program successively
tries all the statements, and we get:
Search WWH ::
Custom Search