Example: Insert Ordered Entries
You could achieve the same result with the following statement:
INSERT INTO employee (10005,'Orebo B',300,,,,'Nov 17 1957',
'M',,,18,);
Using this form, you do not specify column names for fields because you enter the field data in the same order as the columns are defined in the employee table. In all cases, a comma is required as a place marker for any field for which data is not specified.
For ANSI compliance, you should use the keyword NULL for nulls, for example, (10005, ‘Ore60B’, 300, NULL, NULL, NULL, ‘Nov 17 1957’, ‘M’, NULL, NULL, 18).