Create Table Statement
Once you have created database, you may want to create tables to store information.
Create Table Example:
Use following syntax to create table:
CREATE table Orders ( id INT NOT NULL, customer_id INT NOT NULL, date_created DATETIME, date_modified DATETIME, sub_total DOUBLE(10,2), shipping DOUBLE(10,2), tax DOUBLE(10,2), grand_total DOUBLE(10,2), shipping_method VARCHAR(50) );
Once you have created tables, you may want to insert data or retrieve data or alter tables later as requirments changes. For each of these requirements, you will perform different SQL statements.