#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL serv

Question

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the syntax to use near ''tb_admin'(
'id' INT( 4 ) NOT NULL AUTright O_INCREMENT PRIMARY KEY ,
'user' VARCH' at line 1

SQL query:
CREATE TABLE 'tb_admin'('id'INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
'usr'VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
'password'VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
'createtime'DATETIME NOT NULL ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci
最后有个“；”，在查询的时候并没有漏掉

Answer 1

CREATE TABLE 'tb_admin'
(
'id' INT（4） NOT NULL AUTO_INCREMENT PRIMARY KEY ,
'usr' VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , --utf8 COLLATE utf8_unicode_ci 可以去掉，下同
'password' VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
'createtime' DATETIME NOT NULL) --这个地方有括号
ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci；

如果指定了整个表的字符集是utf8 COLLATE utf8_unicode_ci，那么各字段里面就可以不用指定了追问

追答

CREATE TABLE 'tb_admin' --把表名和各字段的单引号全部去掉。。。。
要加的话能用create table `tb_admin`
`这个符号就是～键上的

本回答被提问者采纳

Answer 2

1.You have an error in your SQL syntax：你有一个sql语法错误----检查你的sql语句
2.可能的原因：SQL关键字冲突或者基本sql语法结构有误

Answer 3

ENGINE = MYISAM...前面没括号！

CREATE TABLE `fx_config` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`snserial` varchar(20) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `fx_user_na_ix` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gbk COMMENT='config' |追问

追答

mysql> CREATE TABLE `tb_admin`(
-> `id` int(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> `use` varchar(50),
-> `password` varchar(50),
-> `createtime` datetime not null
-> )engine=MYISAM CHARACTER SET UTF8 COLLATE utf8_unicode_ci;
Query OK, 0 rows affected (0.24 sec)

本回答被网友采纳