Create a student table in MySQL as follows:
Create Table student (s # int (10) Not null auto_increment, sname varchar (10) Not null, sage varchar (5), ssex varchar (5 ), primary key (s #));
Error:
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 'sname varchar (10) Not null,
Sage varchar (5 ),
Ssex varchar (5 ),
Primary key (s
) 'At line 3
Check the syntax carefully without any errors. I do not know the specific cause of the error. Finally, we know that it is caused by the # symbolic link. We can solve it in the following ways:
Create Table student ('s # 'int (10) Not null auto_increment, sname varchar (10) Not null, sage varchar (5), ssex varchar (5 ), primary Key ('s #'));
Note that the symbol 'is the one on the left of the number key 1, not a single quotation mark.
If it is reprinted, please explain the source! Http://blog.csdn.net/xukunddp