Insert
Insert one row — rely on defaults
insert into T values (2);
- k = 2
- x = NULL: Default if no default is specified. (I.e., the "default default".)
- y = 0: Declared default.
- k = NULL: Declared default
insert into T values (3, 30);
- k = 3
- x = 30
- y = 0: Declared default.
- k = NULL: Declared default
DON'T DO THIS
- If columns are added, removed, or order is changed: These insert statements introduces silent bugs.
|