gpt4 book ai didi

MySQL - 尝试插入字符串/数字时出现语法错误

转载 作者:太空宇宙 更新时间:2023-11-03 11:57:54 25 4
gpt4 key购买 nike

<分区>

我收到以下错误:

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 '('text','text','text',1,2,3,4,5,6,7,' at line 4

尝试运行此 SQL 命令时:

insert into `table`
VALUES
(`col1`,`col2`,`col3`,`col4`,`col5`,`col6`,`col7`,`col8`,`col9`,`col10`,`col11`,`col12`,`col13`,`col14`)
('text','text','text',1,2,3,4,5,6,7,8,'text','text','text'),
('text','text','text',11,12,13,14,15,16,17,18,'text','text','text')

更新:我是个彻头彻尾的白痴,在VALUES之前添加了列名...

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com