mysql语句执行不了，怎么办？
- WBOYOriginal
- 2016-06-06 09:41:411435browse
mysql
我用的是mysql-5.6.22-winx64版本，在命令行输入下述语句：
mysql> create table db_shop.tb_admin(
-> 'id' int(4) not null default '0',
-> 'name' varchar(25) default null,
-> 'pwd' varchar(50) default null,
-> primary key('id')
-> );
按回车出现下述语句：
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 ''id'
int(4) not null default '0',
'name' varchar(25) default null,
'pwd' varchar' at line 2
请问各位大侠是什么原因？我执行的语句是照抄书上的原文，我该怎么办？
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql查询学生成绩及各科成绩的排名Next article：怎么比较mysql里不同的两张表的差异;还有mysql和postgres之间同表的差异比较？