You also can specify the NULL keyword in the VALUES clause to indicate that a column should be assigned a NULL value . The following example inserts values into three columns of the orders table: INSERT INTO orders (orders_num, order_date, customer_num) VALUES (0, NULL, 123);