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

admin

mysql> insert into jjj values("yang","23"),("ya","22");
9 Q7 Z! O3 [8 a( x9 ^! x# h/ g9 ~ERROR 1136 (21S01): Column count doesn't match value count at row 1
; w" V" m* f* o0 F) c1 @mysql> alter table jjj modify id int(11) auto_increment;
' y- p+ y9 @$ G% y8 u0 G% W) [9 |Query OK, 0 rows affected (0.16 sec)
" k, m; u5 J* Z( V; E3 l1 yRecords: 0  Duplicates: 0  Warnings: 0
mysql> insert into jjj values("yang","23"),("ya","22");
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> 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
' z, K# z3 S+ f- v" Smysql> select * from jjj;
+----+------+------+
| id | name | age  |
/ B9 M! l! L% r0 f. I$ U( `6 @+----+------+------+
|  1 | yang |   23 |
) A% D7 z& A5 D' b|  2 | ya   |   22 |
9 t! ^% h6 V  B7 n5 j+----+------+------+
# ]- L  z$ q* y+ k2 rows in set (0.00 sec)
mysql>
" X8 V) K* E- u' ^1 Z