INSERT

语法描述

INSERT 用于在表中插入新行。

语法结构

  1. > INSERT INTO [db.]table [(c1, c2, c3)] VALUES (v11, v12, v13), (v21, v22, v23), ...

示例

  1. drop table if exists t1;
  2. create table t1(a int default (1+12), b int);
  3. insert into t1(b) values(1), (1);
  5. mysql> select * from t1;
  6. +------+------+
  7. | a    | b    |
  8. +------+------+
  9. |   13 |    1 |
  10. |   13 |    1 |
  11. +------+------+
  12. 2 rows in set (0.01 sec)
  14. drop table if exists t1;
  15. create table t1 (a date);
  16. insert into t1 values(DATE("2017-06-15 09:34:21")),(DATE("2019-06-25 10:12:21")),(DATE("2019-06-25 18:20:49"));
  18. mysql> select * from t1;
  19. +------------+
  20. | a          |
  21. +------------+
  22. | 2017-06-15 |
  23. | 2019-06-25 |
  24. | 2019-06-25 |
  25. +------------+
  26. 3 rows in set (0.00 sec)
  28. drop table if exists t;
  29. CREATE TABLE t (i1 INT, d1 DOUBLE, e2 DECIMAL(5,2));
  30. INSERT INTO t VALUES ( 6, 6.0, 10.0/3), ( null, 9.0, 10.0/3), ( 1, null, 10.0/3), ( 2, 2.0, null );
  32. mysql> select * from t;
  33. +------+------+------+
  34. | i1   | d1   | e2   |
  35. +------+------+------+
  36. |    6 |    6 | 3.33 |
  37. | NULL |    9 | 3.33 |
  38. |    1 | NULL | 3.33 |
  39. |    2 |    2 | NULL |
  40. +------+------+------+
  41. 4 rows in set (0.01 sec)