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

admin

mysql> insert into jjj values("yang","23"),("ya","22");
- C! P6 n- C% K5 }& ZERROR 1136 (21S01): Column count doesn't match value count at row 1
5 a9 }) c/ C! H2 h& A: f  w* `mysql> alter table jjj modify id int(11) auto_increment;
Query OK, 0 rows affected (0.16 sec)
; [/ G. l6 O3 c3 _: N( ^# \4 ~* @Records: 0  Duplicates: 0  Warnings: 0
% N4 ~4 _  F; i3 a" O. lmysql> insert into jjj values("yang","23"),("ya","22");
) s9 m4 x! L2 j% V" |- p, xERROR 1136 (21S01): Column count doesn't match value count at row 1
; E- ?0 h3 P% imysql> insert into jjj values(,"yang","23"),(,"ya","22");
6 |% i! f, w* G8 ]0 LERROR 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");
# Y7 I$ `' o4 P$ u. D& h  |4 jQuery OK, 2 rows affected, 2 warnings (0.11 sec)
Records: 2  Duplicates: 0  Warnings: 2
* X( F6 c% @. w: emysql> select * from jjj;
7 D" g& ~+ _! ]6 B6 S+----+------+------+
+ w) u  g6 t! K& P' C| id | name | age  |
% q, G& H, i4 i0 K+----+------+------+
5 p7 X* F# V) Y1 A& H|  1 | yang |   23 |
|  2 | ya   |   22 |
+ z% ?) y& W9 @. A7 z; i8 E% A9 _+----+------+------+
. ]6 B6 q( g+ h2 A. L: T2 rows in set (0.00 sec)
5 y9 E! |$ r% V' t, D2 @; xmysql>
: ~% G' C, L+ U, C: q* Q( Y. Z