INSERT Syntax
Every database starts out empty.
You must first create the table definition using SQL’s Data Definition Language, which we will cover in a future section.
When you have defined the table, it still contains no data.
You must INSERT data into the table to make it useful.
The INSERT statement adds one or more rows to a table.
INSERT INTO table
[(COLUMN1, COLUMN2, ...)]
[VALUES ([value1, value2, ...
| hostvariable, ...
| expression, ...
|NULL, ...
| specialregister, ...)
| subselect];
> This is the only way to load data into tables per the SQL standard.
However, many vendors have their own tools for loading tables.
For example, Oracle has a utility called SQL *Loader.
Go on and we will cover the details.