mysql> show columns from stuinf_A2241 from students;
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| stu_id | bigint(20) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | YES | | NULL | |
| class | varchar(20) | YES | | NULL | |
| sex | varchar(8) | YES | | NULL | |
| birthday | varchar(255) | YES | | NULL | |
| ethnic | varchar(255) | YES | | NULL | |
| nativeplace | varchar(255) | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
7 rows in set (0.02 sec)mysql> insert inot stuinf_A2241(stu_id,name,class,sex,
-> birthday,ethnic,nativplace) values(
-> 1,'小张','男','A2241','1985-07-20','汉','江苏');
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 'stuin
f_A2241(stu_id,name,class,sex,
birthday,ethnic,nativplace) values(
1,'小张'' at line 1
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| stu_id | bigint(20) | NO | PRI | NULL | auto_increment |
| name | varchar(20) | YES | | NULL | |
| class | varchar(20) | YES | | NULL | |
| sex | varchar(8) | YES | | NULL | |
| birthday | varchar(255) | YES | | NULL | |
| ethnic | varchar(255) | YES | | NULL | |
| nativeplace | varchar(255) | YES | | NULL | |
+-------------+--------------+------+-----+---------+----------------+
7 rows in set (0.02 sec)mysql> insert inot stuinf_A2241(stu_id,name,class,sex,
-> birthday,ethnic,nativplace) values(
-> 1,'小张','男','A2241','1985-07-20','汉','江苏');
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 'stuin
f_A2241(stu_id,name,class,sex,
birthday,ethnic,nativplace) values(
1,'小张'' at line 1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货