On Tuesday, 26. February 2002 00:33, Bob Rea wrote: > I'm getting a syntax error when I try to insert more two > sets of values into a table. > > I have looked at the manual on the insert statement, and > don't see what is wrong. >
> ERROR 1064: You have an error in your SQL syntax near > 'values( > '0-312-25313-3', > 'Coup de Grace', > 'Borthwick', > 'J S', > "St Martin's Minot' at line 21 Correct Syntax is INSERT INTO table (fields,..) VALUES (values,...) You try to use to insert 2 or more records with one insert statement, that isnt allowed, and therefore the syntax error. Regards Georg mysql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
