CREATE TABLE Orders (
order_id INT(11) NOT NULL,
order_date DATE NOT NULL,
items_count INT(11) DEFAULT 1
)
| SQL enables you to specify default values to be used if no value is specified when a row is inserted. Default values are specified using the DEFAULT keyword in the column definitions in the CREATE TABLE statement. |