Use CREATE TABLE statement to create a new table in MySQL database. You must create and select a database to create tables in it. Syntax: CREATE TABLE [IF NOT EXISTS] table_name ( coloumn1, coloumn2 ) engine=table_type; Here [IF NOT EXISTS] is used to create table only if there are no existing table with the name. The database engine can be used as per your requirements. A column can be defined as following. column_name data_type[size] [NOT NULL|NULL] [DEFAULT value] [AUTO_INCREMENT], Example: For example, create table users to store information of our…
Read More