MySQL創(chuàng)建表格的時(shí)候
create table 'users'
(
'ID' Int(11) not null auto_increment comment '主鍵',
'username' varchar(32) not null,
'password' varchar(32) character set utf8 default null,
'realname' varchar(32) character set utf8 default null,
'gender' varchar(32) character set utf8 default null,
'age' Int(11) not null,
'PersonalSignature' varchar(1024) character set utf8 default null,
primary key ('ID')
)engine = InnoDB;
報(bào)錯(cuò)，一直報(bào)錯(cuò)卷谈，這里用的是單引號(hào)
create table `users`
(
`ID` Int(11) not null auto_increment comment '主鍵',
`username` varchar(32) not null,
`password` varchar(32) character set utf8 default null,
`realname` varchar(32) character set utf8 default null,
`gender` varchar(32) character set utf8 default null,
`age` Int(11) not null,
`PersonalSignature` varchar(1024) character set utf8 default null,
primary key (`ID`)
)engine = InnoDB;
正確杯拐，這里用的是反單引號(hào)，不報(bào)錯(cuò)
總結(jié)：
1.表、字段等用什么符號(hào)端逼？用反引號(hào)或者不用朗兵，用單引號(hào)會(huì)產(chǎn)生錯(cuò)誤；
2.字符串需要使用單引號(hào)或著雙引號(hào)顶滩。
