The insert statement exported by tools is incorrect. The exported result
Insert to values (ENTERNO, sequence, sequence, INNO, INTP, INBILLNO, PRODENTERID, PRODLVL, BIGVARIETY, SMALLVARIETY, SPECIFICATION, PIECE, BOXES, PRICE, TOTALAMT, PRODDT, VALIDDT, ENDDT, INDT, KEEPERIDCARD, delimiter, delimiter, FROMRETAILENTERNO, CURBOXES, BULKCARGOBILLNO, ISREPORT, REPORTTIME, INTABLETM, IDCARD, FILLDATE, BARCODEVALUE, MEMO) values ('123', '123456 ', '01', '123', '01', '[NULL]', '123', '2', '02', '13', '[NULL]', '[NULL]', '123456', '[NULL]', '0. 0', '[NULL]', '[NULL]', '[NULL]', '2017-01-02 ',' [NULL] ',' [NULL] ', '[NULL]', '[NULL]', '123', '[NULL]', '00', '[NULL]', '14: 49: 13 ', '[NULL]', '2017-01-11 ',' [NULL] ',' [NULL] ')
MySQL Error Code: 1064 Solution
If insert into is written incorrectly, '[ NULL] 'is changed to NULL. The field in the table should have ''and finally; the table ends.
You should be cautious when using your own tools.
From minz's blog