|< < 4 > >|

Insert

The insert statement inserts one or more rows into a table.

Scripts: insert.sql.

Schema


create table T(
    k int not null primary key,
    x int,
    y int default 0,
    z varchar default null
);

Insert one row — all columns


insert into T values (1, 10, 111, 'hello');

Inserts one row, with:

k = 1
x = 10
y = 111
z = 'hello'

|< < 4 > >|