-
Notifications
You must be signed in to change notification settings - Fork 57
/
s2.sql
28 lines (21 loc) · 785 Bytes
/
s2.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
-- examples on insert
-- the current table status
select *
from service;
-- plain insert
insert into service (service_id, name, location_id) values
(20, 'Mirdor Shifty Solutions', 1100);
-- multiline insert
insert into service (service_id, name, location_id) values
(21, 'Old Gondor Messingup', 1200),
(22, 'Rohan Leather Finitures', 1300);
-- column with default value (nullable or other) could be skipped
insert into service (service_id, name) values
(12, 'Kerr & Reetch Associates');
-- auto-incremented value for pk
insert into service (name) values ('Multiple Oz');
-- using default values for each column
insert into service (name) values (DEFAULT);
-- insert relying on column definition on table
insert into service values
(13, 'Rainydays Carwash', null);