INSERT

After the table is created, the user can insert the corresponding values of each column (attribute) into the table by using the INSERT statement.

The general syntax for the Insert statement is following:

INSERT INTO table_name VALUES (value1, value2, ...)

In our ABC company example, the staff can insert the values into those tables he created by following methods:

INSERT INTO Product VALUES ('2','Throwback Cola', 'Pepsi', 'Pepsico','0', '0', 'soda', '12.01', '3.11', '8.9')  

INSERT INTO Customer VALUES ('4', 'Julia Kennedy', 'Italian', 'Florida', 'Fivespan', 'Female', '30')

INSERT INTO sales VALUES ('8713', '366', 'CVS', '2013-01-01 00:06:30', '6', '77.94'), ('8713', '3263','7-11', '2013-01-01 00:09:52', '2', '19.94')

Note

Inserting data into a dimension table with existing key will replace previous data.

If ON DUPLICATE KEY UPDATE clause is specified when inserting data into a table with an unique key, an UPDATE will be performned on the row if a duplicate key is found.

The general syntax is as follows:

INSERT INTO table_name VALUES (value1 [, value2 ...]) ON DUPLICATE KEY UPDATE
   col = expr [, col=expr] ... ]

INSERT INTO table_name SELECT ... ON DUPLICATE KEY UPDATE
   col = expr [, col=expr] ... ]