Error on SQL insert statement

Posted by Ashley Stewart on Stack Overflow See other posts from Stack Overflow or by Ashley Stewart
Published on 2014-06-03T03:13:42Z Indexed on 2014/06/03 3:25 UTC
Read the original article Hit count: 228

Filed under:
|

I exported a recordset from one database into a csv file, and when I try to import it into another using mysql workbench I keep this this error message:

Executing SQL script in server

ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'Lord it Over', 'Ben', '1993-03-01', 'TRC', NULL, 1983, '1999-09-01', 'NULL', '' at line 1



INSERT INTO `TRC`.`horse` 
(`horse_id`, `registered_name`, `stable_name`, `arrival_date`, `last_known_location`, `is_ex_racer`, `birth_year`, `death_date`, `horse_comments`, `sex`, `referral_date`, `horse_height`, `arrival_weight`, `passport_no`, `microchip_no`, `is_on_waiting_list`) VALUES 
(, 'Lord it Over', 'Ben', '1993-03-01', 'TRC', NULL, 1983, '1999-09-01', 'NULL', 'NULL', 'NULL', NULL, NULL, 'NULL', 'NULL', 0)



SQL script execution finished: statements: 29 succeeded, 1 failed



Fetching back view definitions in final form.

Nothing to fetch

Any help would be appreciated as their appears to be no errors as far as I can see.

© Stack Overflow or respective owner

Related posts about mysql

Related posts about mysql-workbench