Practical C Programming

Create table

This creates a database table with the specified name. Here is its syntax:

CREATE TABLE table_name (column_name column_type,column_name column_type,.....);

Here:

• table_name represents the name of the table that we want to create.
• column_ name represents the column names that we want in the table.
• column_type represents the data type of the column. Depending on the type of data we want to store in the column, the column_type can be int, varchar, date, text, and so on.

The create table statement creates a users table with three columns: email_address, password, and address_of_delivery. Assuming that this table will contain information of the users who have placed orders online, we will be storing their email address, password, ...