Create table `studentgl`.`User`(
`UserName` varchar(20) NOT NULL,
`Password` varchar(20) NOT NULL DEFAULT '888888',
`Level` bit(1) NOT NULL DEFAULT (1),
`Status` bit(1) NOT NULL DEFAULT (1),
primary key (`UserName`)
)
错误信息:
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 '(1),
`Status` bit(1) NOT NULL DEFAULT (1),
primary key (`UserName`)
)' at line 4
`UserName` varchar(20) NOT NULL,
`Password` varchar(20) NOT NULL DEFAULT '888888',
`Level` bit(1) NOT NULL DEFAULT (1),
`Status` bit(1) NOT NULL DEFAULT (1),
primary key (`UserName`)
)
错误信息:
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 '(1),
`Status` bit(1) NOT NULL DEFAULT (1),
primary key (`UserName`)
)' at line 4
解决方案 »
- mysql里utf8编码,请问怎么匹配指定长度的文字?
- ERROR 2002 (HY000): Can't connect to local MySQL server through socket
- mysql 2个时间相差的毫秒数的问题
- 关于多表查询
- ★★★求一统计SQL语句!★★★
- 创建数据库 在线等~~~
- 一个关于日期的问题!紧急求助!
- MySQL/Postgresql 有没有c语言的api接口?
- mysql in (set) set过大,应该如何调优
- 这个编码,真的不能改啊?
- 求大牛们帮个忙!感激不尽!急!!powerdesigner生成 的sql脚本错误
- 求救!mysql的多表查询统计问题
`UserName` varchar(20) NOT NULL,
`Password` varchar(20) NOT NULL DEFAULT '888888',
`Level` bit(1) NOT NULL DEFAULT b'1',
`Status` bit(1) NOT NULL DEFAULT b'1',
primary key (`UserName`)
)