INSERT into ' Ftms_active_dealer ' (dealer_code,dealer_name,active_id,dealer_state) VALUES (' 415a1 ', ' He Lei ' 10023 ', ' 1 '),
(' 31042 ', ' Wei ' 10023 ', ' 1 ');
[ERR] 1064-you has an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near ' 10023 ', ' 1 '),
(' 31042 ', ' Wei ' 10023 ', ' 1 ') ' at line 2
A lot of information on the web, most of the error occurred in the CREATE table or stored procedure column name called the system function name or stored procedure syntax is not correct, such as multiple ', ' What, insert problem is rare, the investigation of a half-day, the original is the old eye dim .... Inserting is clearly 4 columns, resulting in one less of the values, resulting in 3 columns.
INSERT into ' Ftms_active_dealer ' (dealer_code,dealer_name,active_id,dealer_state) VALUES (' 415a1 ', ' He Lei ', ' 10023 ', ' 1 ') ,
(' 31042 ', ' Wei ', ' 10023 ', ' 1 ');
Normal after correction.
[ERR] 1064-you has an error in your SQL syntax; Check the manual that corresponds ...