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

admin

mysql> insert into jjj values("yang","23"),("ya","22");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
4 R2 Q/ Q5 P% W7 i$ pmysql> alter table jjj modify id int(11) auto_increment;
* X: f! W+ ?) P6 f( P& PQuery OK, 0 rows affected (0.16 sec)
' B, J0 _% D, z+ KRecords: 0  Duplicates: 0  Warnings: 0
+ E8 }1 N. t7 W2 x& x) _mysql> insert into jjj values("yang","23"),("ya","22");
7 u% U4 N; k* a: p- d# h9 iERROR 1136 (21S01): Column count doesn't match value count at row 1
8 r4 Q( N% a! }" w5 f1 a$ Gmysql> insert into jjj values(,"yang","23"),(,"ya","22");
& ?+ @% B  B1 Y4 hERROR 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)
" T9 j( [. y; r- F: K6 l" oRecords: 2  Duplicates: 0  Warnings: 2
6 R/ g8 H4 P9 G3 a2 T- M" Imysql> select * from jjj;
+----+------+------+
| id | name | age  |
4 Q, x% N+ b' F3 P+----+------+------+
- |+ g7 Z5 X, l4 l|  1 | yang |   23 |
|  2 | ya   |   22 |
$ J2 @  e6 s3 t' z; D" {9 S+----+------+------+
2 rows in set (0.00 sec)
mysql>