示例表及数据基于以下定义：

  2. Query OK, 0 rows affected (0.16 sec)
  4. OceanBase(admin@test)>create table t2(c1 int primary key, c2 int);
  5. Query OK, 0 rows affected (0.16 sec)
  6. OceanBase(admin@test)>select * from t2;
  7. +----+------+
  8. | c1 | c2   |
  9. +----+------+
  10. |  1 |    1 |
  11. |  2 |    2 |
  12. |  3 |    3 |
  13. |  4 |    4 |
  14. +----+------+
  15. 4 rows in set (0.06 sec)
  • 向表 t1 中插入一行数数据。
  1. OceanBase(admin@test)>insert t1 values(1,1),(2,default),(2+2,3*4);
  2. Query OK, 3 rows affected (0.02 sec)
  3. Records: 3  Duplicates: 0  Warnings: 0
  5. OceanBase(admin@test)>select * from t1;
  6. +----+------+
  7. | c1 | c2   |
  8. +----+------+
  9. |  1 |    1 |
  10. |  2 | NULL |
  11. |  4 |   12 |
  12. +----+------+
  13. 3 rows in set (0.02 sec)
  • 向表 t1 指定的 p0 分区插入单行数据。
  • 将表 t2 的查询结果作为数据插入表 t1。
  1. OceanBase(admin@test)>insert into t1 select * from t2;
  2. Query OK, 4 rows affected (0.02 sec)
  3. Records: 4  Duplicates: 0  Warnings: 0
  5. OceanBase(admin@test)>select * from t1;
  6. | c1 | c2   |
  7. +----+------+
  9. |  2 |    2 |
  10. |  3 |    3 |
  11. |  4 |    4 |
  12. +----+------+
  13. 4 rows in set (0.01 sec)
  • 向表 t1 中插入重复主键值时利用 ON DUPLICATE KEY UPDATE 功能进行值更新
  • 对可更新视图v的插入值
  1. OceanBase(admin@test)>create view v as select * from t1;
  2. Query OK, 0 rows affected (0.07 sec)
  3. OceanBase(admin@test)>insert into v values(1,1);
  4. Query OK, 1 row affected (0.01 sec)
  6. OceanBase(admin@test)>select * from v;
  7. +----+------+
  8. | c1 | c2   |
  9. +----+------+
  10. |  1 |    1 |
  11. 1 row in set (0.02 sec)