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

admin

mysql> insert into jjj values("yang","23"),("ya","22");
$ C5 u$ ^2 B: i) P# I9 j8 KERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> alter table jjj modify id int(11) auto_increment;
Query OK, 0 rows affected (0.16 sec)
9 `2 q4 Z& |) w# ?5 q9 zRecords: 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");
6 m8 B! P3 S0 K* z) j7 |1 ?8 v. zQuery OK, 2 rows affected, 2 warnings (0.11 sec)
Records: 2  Duplicates: 0  Warnings: 2
mysql> select * from jjj;
+----+------+------+
| id | name | age  |
( n* g* K4 B, S+ Z5 p+----+------+------+
- u, q, h9 m$ B6 Z; ]|  1 | yang |   23 |
$ k: R. {( g2 F9 u# q|  2 | ya   |   22 |
! R: e. |! S$ `6 P8 C+----+------+------+
2 rows in set (0.00 sec)
+ a6 V4 g% `/ k3 P& z# Q; kmysql>
  L& V$ U: \. L" |! s