4.1

The INSERT Clause With a Column List

The INSERT Clause With a Column List

Below is a basic example of an INSERT statement with a column list:

1    USE world;
2    INSERT INTO city 
3        (name, countryCode, district, population) 
4    VALUES 
5        ("San Felipe", "CHL", "Valparaiso", 64126);

Results:

iud_01.png

Results of the Insert:

iud_02.png

INSERT INTO city

(name, countryCode, district, population) 

VALUES

("San Felipe", "CHL", "Valparaiso", 64126);

CC BY-NC-ND International 4.0

CC BY-NC-ND International 4.0: This work is released under a CC BY-NC-ND International 4.0 license, which means that you are free to do with it as you please as long as you (1) properly attribute it, (2) do not use it for commercial gain, and (3) do not create derivative works.