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
( p. y, r- T; b* s0 rmysql> insert into jjj values("yang","23"),("ya","22");
8 B& D5 d3 ^. R2 A, ]8 Q. AERROR 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");
! W3 A! m" ^( K! F1 _; PQuery OK, 2 rows affected, 2 warnings (0.11 sec)
3 R# B' _" W3 a* t2 S  P6 ORecords: 2  Duplicates: 0  Warnings: 2
# l; `3 {5 {6 ]+ _1 ^! Xmysql> select * from jjj;
+----+------+------+
* c$ f1 C' E) k) l, y% P$ W| id | name | age  |
+----+------+------+
|  1 | yang |   23 |
|  2 | ya   |   22 |
+----+------+------+
3 o* @. c% f0 v/ k7 k( l$ ~6 F2 rows in set (0.00 sec)
# ^0 k9 _! z: W( imysql>