ERROR 1136 (21S01): Column count doesn't match value count at row 1 数据库插入数据自动增长

admin

mysql> insert into jjj values("yang","23"),("ya","22");
; B4 o& x: Z) l4 g9 Z3 a# t; }# ]ERROR 1136 (21S01): Column count doesn't match value count at row 1
$ `; f( J2 ?6 L6 o( L& kmysql> alter table jjj modify id int(11) auto_increment;
7 c/ N2 w$ s4 ]+ g# K, HQuery OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0
+ X7 v6 _* q# fmysql> insert into jjj values("yang","23"),("ya","22");
4 a% T) g0 a- [. M; d* mERROR 1136 (21S01): Column count doesn't match value count at row 1
* R& s! M4 A1 A, h4 e& Xmysql> insert into jjj values(,"yang","23"),(,"ya","22");
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 '"yang","23"),(,"ya","22")' at line 1
mysql> insert into jjj values(" ","yang","23"),(" ","ya","22");
Query OK, 2 rows affected, 2 warnings (0.11 sec)
Records: 2  Duplicates: 0  Warnings: 2
mysql> select * from jjj;
) Z! M+ ]$ c) b7 Y6 O9 K) t7 O+----+------+------+
| id | name | age  |
+----+------+------+
|  1 | yang |   23 |
|  2 | ya   |   22 |
+----+------+------+
2 rows in set (0.00 sec)
mysql>