完美解决 ERROR 1064 (42000): You have an error in your SQL syntax ... near …
来源:互联网 发布:手机密码下载软件 编辑:程序博客网 时间:2024/06/06 02:47
在MySQL命令行使用sql语句进行建表时,MySQL 报错,这个问题之前遇到过几次,但是总是会因为疏忽又相遇,今天把这个问题写出来,加深印象吧。
sql语句:
CREATE TABLE 'lrs_audit_rule_package'( 'id' BIGINT(20) AUTO_INCREMENT PRIMARY KEY COMMENT '主键', 'package_code' varchar(6) NOT NULL COMMENT '规则包', 'package_type' varchar(2) NOT NULL COMMENT '规则包类型', 'package_desc' varchar(100) COMMENT '描述', 'create_time' datetime DEFAULT NULL COMMENT '创始时间', 'modified_time' datetime DEFAULT NULL COMMENT '修改时间') ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='审核规则包';
看上去这条sql语句确实没毛病,但是运行起来就是报错
报错信息:
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 ''lrs_audit_rule_package'( 'id' BIGINT(20) AUTO_INCREMENT PRIMARY KEY COMMENT ' at line 1
其实这个问题就是语法上的错误,在MySQL中,为了区分MySQL的关键字与普通字符,MySQL引入了一个反引号。
详情见:https://dev.mysql.com/doc/refman/5.5/en/keywords.html
在上述的sql语句中,列名称使用的是单引号而不是反引号,所以会就报了这个错误出来。修改后
CREATE TABLE `lrs_audit_rule_package`( `id` BIGINT(20) AUTO_INCREMENT PRIMARY KEY COMMENT '主键', `package_code` varchar(6) NOT NULL COMMENT '规则包', `package_type` varchar(2) NOT NULL COMMENT '规则包类型', `package_desc` varchar(100) COMMENT '描述', `create_time` datetime DEFAULT NULL COMMENT '创始时间', `modified_time` datetime DEFAULT NULL COMMENT '修改时间') ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='审核规则包';
再次运行就不会报错了,但是有一点需要注意,后面列的注释不能用反引号,因为这只是一个普通字符串,不是MySQL的关键字。
在英文键盘输入环境下,按图示按钮输入反引号 `
9 0
- 完美解决 ERROR 1064 (42000): You have an error in your SQL syntax ... near …
- 1064 - You have an error in your SQL syntax问题解决
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL 完美解决
- Error 1064(42000):you have an error in your sql syntax;一个简单的原因
- ERROR 1064 (42000): You have an error in your SQL syntax
- You have an error in your SQL syntax
- MySql JDBC:You have an error in your SQL syntax;
- You have an error in your SQL syntax的解决方法
- 抛出 异常 You have an error in your SQL syntax...
- You have an error in your SQL syntax;解决方法
- You have an error in your SQL syntax;
- You have an error in your SQL syntax
- You have an error in your SQL syntax;
- You have an error in your SQL syntax;
- You have an error in your SQL syntax
- You have an error in your SQL syntax;
- 异常之You have an error in your SQL syntax
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
- 199. Binary Tree Right Side View | 从右边看二叉树得到的集合
- Lumen中使用JWT-Auth刷新token实现方式
- 欢迎使用CSDN-markdown编辑器
- react-native 实现条码扫描(ios&android)
- LeetCode | 18. 4Sum
- 完美解决 ERROR 1064 (42000): You have an error in your SQL syntax ... near …
- 动态规划练习06:登山
- SSM+JQuery+Ajax登录验证
- Android App 沉浸式状态栏解决方案
- Makefile的作用
- java并发包:生产者消费者模式
- 如何使用阿里百川hotfix热修复功能(二)
- 文章标题 CSU 1843: Jumping monkey (状态压缩+dp)
- spring-mvc注解式格式化属性数据