MySQL插入带日期的行

Question

use TREND_INFORMATION

INSERT INTO log_index_level_1
(LOG_INDEX, LOT_ID, WAFER_ID, MAP_REV, PROBE_DATE)
(42, "2819893.003", "9893-06", "PR20", "2013-07-13");

我不断收到以下错误，我不确定自己做错了什么。

列类型分别为 int 、 varchar 、 varchar 、 varchar 和 date 。

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL s er version for the right syntax to use near '42, "asdfasfasf", "asdfas", "tes", '2013-07-13')' at line 3

Answer 1

您缺少关键字 VALUES

INSERT INTO log_index_level_1
(LOG_INDEX, LOT_ID, WAFER_ID, MAP_REV, PROBE_DATE)
VALUES -- <-- That's what you're missing
(42, "2819893.003", "9893-06", "PR20", "2013-07-13");