4.1

The INSERT Clause With a Column List

The INSERT Clause With a Column List

  • You can INSERT single or multiple rows at a time.
  • An INSERT with a column list DOES NOT require you to provide a value for each column. If you do not want to provide a value for a specific column, you do not have to include it in the column list. For columns that allow null values, the system will automatically provide a null value for you.
  • If you want a column that provides a default value such as an auto-increment column to be populated with the default value, you do not need to list the column in the column list. The system will automatically provide the default value.
  • When coding with a column list, the columns may appear in any order as long as the VALUES list matches the order of the 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);

This content is provided to you freely by BYU-I Books.

Access it online or download it at https://books.byui.edu/learning_mysql/the_insert_clause_wi.