Todd Hewett wrote:
I currently am failing with the following:mysql> INSERT INTO VCS_PO_NUMBER (VCS_PO_NUMBER) VALUES(899234), -> INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) VALUES(36534), -> INSERT INTO BOARD_TYPE (BOARD_TYPE) VALUES(INPUT MODULE N12310), -> INSERT INTO RECIEPT_INSPECTION (RECIEPT_INSPECTION_NAME) VALUES(BILlTHOMAS), -> INSERT INTO PCB_MANUFACTURER (PCB_MANUFACTURER_COMPANY_NAME) VALUES(A); ERROR 1064: You have an error in your SQL syntax near 'INSERT INTO BOARD_SERIAL_NUMBER (BOARD_SERIAL_NUMBER) VALUES(36534), INSERT INTO' at line 2
You need to end each INSERT INTO statement with a semicolon (;), not a comma (,). Also pressing <enter> after each one will allow you to easier diagnose any problems that might come up.
-- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
