I am using the mysql-5.6.22-winx64 version and enter the following statement on the command line: mysql & gt; createtable 'DB _ shop '. 'TB _ admin' (-& gt; & #39; id & #39; int (4) notnulldefault & #39; 0 & #39;,-& gt; & #39; name & #39; varchar (25) defaultnull,-& gt; & #39; pwd & #39; varchar (50) defaultnull,-& gt; primarykey (mysql
I'm using the mysql-5.6.22-winx64 version and enter the following statement on the command line:
Mysql> create tableDb_shop.Tb_admin(
-> 'Id' int (4) not null default '0 ',
-> 'Name' varchar (25) default null,
-> 'Pwd' varchar (50) default null,
-> Primary key ('id ')
-> );
Press enter to display the following statement:
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
What are the reasons? The statement I run is a copy of the original text in the book. what should I do?