in reply to Re^2: Inserting Multiple Records in DB.
in thread Inserting Multiple Records in DB.

In standard-SQL, you can insert multiple rows of data with a single INSERT statement.

Thank you! This was news to me. I've done my due-diligence Googling now, and I see it's true.

But when I look at the OP's code, I can't see any syntactic markers for multiple records. The multirow INSERT ... VALUES statement looks like

INSERT INTO phone_book VALUES ('John Doe', '555-1212'), ('Peter Doe', +'555-2323');

with a pair of parentheses for each record to be inserted.

Thanks also to pc88mxer below for the diligent analysis of the parsing routine, confirming that there should be multiple target tables.