|
|
mysql> insert into jjj values("yang","23"),("ya","22");
1 @( G' _0 S ^9 q" P+ U2 |ERROR 1136 (21S01): Column count doesn't match value count at row 1
# f3 m' Q. T8 w3 Z2 e3 K dmysql> alter table jjj modify id int(11) auto_increment;4 b8 |; X8 m) v& e) G" W: y T
Query OK, 0 rows affected (0.16 sec)
5 H$ P9 e/ W! D c5 |4 HRecords: 0 Duplicates: 0 Warnings: 0
/ W# \( O+ {" Z9 D- H' P1 Vmysql> insert into jjj values("yang","23"),("ya","22");# |+ ?' Q, `; _+ x8 Z" G4 `
ERROR 1136 (21S01): Column count doesn't match value count at row 11 V" {. ~: K0 ~( N4 Y. z
mysql> insert into jjj values(,"yang","23"),(,"ya","22");
$ s, u/ h+ [) R3 {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
1 n! n- y v# b, ]; _( i1 Tmysql> insert into jjj values(" ","yang","23"),(" ","ya","22");! q; g. |) |4 d5 C& p0 t+ K
Query OK, 2 rows affected, 2 warnings (0.11 sec)7 [& l2 T& W. O. ^7 a8 I& i c
Records: 2 Duplicates: 0 Warnings: 2
9 N7 D/ n/ Q! a; tmysql> select * from jjj;
2 O# C2 O$ l8 s/ D+----+------+------++ ^7 T# R6 T4 Y* Y) `. _1 w% ?
| id | name | age |
1 K+ l* q x9 c) N+----+------+------+) S3 g6 S, z- ~
| 1 | yang | 23 |$ ^7 ~9 l/ w3 _) y4 m- h
| 2 | ya | 22 |
3 ?& p% ]" Q' [& M5 i! B+----+------+------+) y. z7 v3 F& D; t1 d
2 rows in set (0.00 sec)
7 @. A# [2 I" n7 L" j) Imysql>
- y. w5 X/ N% U2 ^7 w |
|
发表于 2020-6-18 09:50:19