INSERT INTO sh_goods_comment (id, user_id, goods_id, content,is_show, create_time) VALUES (1,1,8,'好',0,'2017-11-08 00:00:00'), (2,2,10,'不错',1,'2017-12-03 00;00:00') (3,3,9,'满意',1,12017-12-30 00:00:00'), (4,4,4,'携带方便',1,'2018-01-19 00:00:00'), (5,4,7,'中低音效果特别棒',1,'2018-01-19 00:00:00'),(6,5,8,'卡机',1,2018-01-22 00:00:00'), (7,6,5,'黑夜拍照也清晰’,1,'2018-02-15 00:00:00') (8,7,9,'掉色、有线头',0,12018-03-03 00:00:00'), (9,4,9,'还行',1,'2018-04-05 00:00:00'), (10,8,9,'特别彰显气质',1,2018-04-16 00:00:00');语法有错误吗
时间: 2023-12-25 07:06:03 浏览: 88
是的,这条 SQL 语句有语法错误。在第2个和第5个值列表之间缺少逗号,应该改为:
```
INSERT INTO sh_goods_comment (id, user_id, goods_id, content, is_show, create_time)
VALUES
(1, 1, 8, '好', 0, '2017-11-08 00:00:00'),
(2, 2, 10, '不错', 1, '2017-12-03 00:00:00'),
(3, 3, 9, '满意', 1, '2017-12-30 00:00:00'),
(4, 4, 4, '携带方便', 1, '2018-01-19 00:00:00'),
(5, 4, 7, '中低音效果特别棒', 1, '2018-01-19 00:00:00'),
(6, 5, 8, '卡机', 1, '2018-01-22 00:00:00'),
(7, 6, 5, '黑夜拍照也清晰', 1, '2018-02-15 00:00:00'),
(8, 7, 9, '掉色、有线头', 0, '2018-03-03 00:00:00'),
(9, 4, 9, '还行', 1, '2018-04-05 00:00:00'),
(10, 8, 9, '特别彰显气质', 1, '2018-04-16 00:00:00');
```
修改后,这条 SQL 语句就可以成功执行了。
阅读全文