DROPTABLEIFEXISTS`user`;CREATETABLE`user`(`intID`int(11)NOTNULLauto_increment,`vcName`varchar(20)NOTNULL,`vcPassword`varchar(20)NOTNULL,`vcSex`varchar(2)NOTNULL,PRIMARYKE...
DROP TABLE IF EXISTS `user`; CREATE TABLE `user` ( `intID` int(11) NOT NULL auto_increment, `vcName` varchar(20) NOT NULL, `vcPassword` varchar(20) NOT NULL, `vcSex` varchar(2) NOT NULL, PRIMARY KEY (`intID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; mysql> CREATE TABLE 'aaa' ( -> 'intID' int(11) NOT NULL auto_increment, -> 'vcName' varchar(20) NOT NULL, -> 'vcPassword' varchar(20) NOT NULL, -> 'vcSex' varchar(2) NOT NULL, -> PRIMARY KEY ('intID') -> )ENGINE=InnoDB DEFAULT CHARSET=latin1; ERROR 1064 (42000): 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 ''aaa' ( 'intID' int(11) NOT NULL auto_increment, 'vcName' varchar(20) NOT NULL, ' at line 1 上面的和下面的没区别呀,就一个表名不一样而以,为啥创建不了呢??搞不明白
展开