我的sql语句:
INSERT INTO w_file_t (can_delete, create_time, creator, deleted, DESCRIBE, download_url, MODIFIER, modify_time, NAME, size, VERSION, id)
VALUES ("Y", 151234561111, "3", "3", "fuckoff",
"http://jlkj01.oss-cn-chengdu.aliyuncs.com/resource/系统规划报告20200421154132098.docx", "3", 151234561111, "空文档.docx", 11908, 2, "9869a38e43d233e19202a2703fd7acdb")
错误提示:
错误代码: 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 'describe, download_url, modifier, modify_time, name, size, version, id)
values ' at line 1
其中的一个1064错误 , 在原来的基础上增加了一个describe字段 , 执行插入语句报错 , 后来修改成其他的字段插入成功 , 查询了一下是说describe是mysql的关键字 , 嗯 , 不加前后缀不敢用这个字段了