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

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

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)

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

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`
`这个符号就是～键上的