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