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
mysql> alter table jjj modify id int(11) auto_increment;
Query OK, 0 rows affected (0.16 sec)
Records: 0  Duplicates: 0  Warnings: 0
4 T6 D1 ]( p, U  U$ imysql> insert into jjj values("yang","23"),("ya","22");
3 `8 J3 Y( S2 q2 e" rERROR 1136 (21S01): Column count doesn't match value count at row 1
4 m- q% N/ @! `! pmysql> insert into jjj values(,"yang","23"),(,"ya","22");
$ A7 K- \  ]' G) O# UERROR 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
) N% v% V* D/ R) kmysql> insert into jjj values(" ","yang","23"),(" ","ya","22");
' b5 X& C9 c8 l, {Query OK, 2 rows affected, 2 warnings (0.11 sec)
, z/ z1 r2 L3 J, }* u' eRecords: 2  Duplicates: 0  Warnings: 2
5 x) \) R; P4 N$ x0 h0 l/ M, ]mysql> select * from jjj;
  v% a9 M7 {9 F& l' r# _( r+----+------+------+
| id | name | age  |
1 P5 _$ e! D! d, X+----+------+------+
|  1 | yang |   23 |
|  2 | ya   |   22 |
+----+------+------+
/ p/ @/ u5 s$ V$ H- {' a$ B7 e2 rows in set (0.00 sec)
. q3 M0 q8 _8 o  J5 Rmysql>
  ~1 {' @& V5 K4 n5 n/ {