INSERT

Description

Writing data.

Syntax

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

Examples

  1. > CREATE TABLE test(a int, b varchar(10));
  2. > INSERT INTO test values(123, 'abc');
  3. > SELECT * FROM test;
  4. +------+---------+
  5. | a | b |
  6. +------+---------+
  7. | 123 | abc |
  8. +------+---------+