MySQL Create table

A table is used to organize data in the form of rows and columns and used for both storing and displaying records in the structure format. It is similar to worksheets in the spreadsheet application. A table creation command requires three things:

1. Name of the table

2. Names of fields

3. Definitions for each field

    CREATE TABLE [IF NOT EXISTS] table_name(  
        column_definition1,  
        column_definition2,  
        ........,  
        table_constraints  
    );  

database_name It is the name of a new table. It should be unique in the MySQL database that we have selected. The IF NOT EXIST clause avoids an error when we create a table into the selected database that already exists.

column_definition It specifies the name of the column along with data types for each column. The columns in table definition are separated by the comma operator. The syntax of column definition is as follows: column_name1 data_type(size) [NULL | NOT NULL]

table_constraints It specifies the table constraints such as PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK, etc.

For example :

Let us understand how to create a table into the database with the help of an example. Open the MySQL console and write down the password, if we have set during installation. Now open the database in which you want to create a table. Here, we are going to create a table name "employee_table" in the database "employeedb" using the following statement:

Let's move on to alter table command in MySQL

Share this page on :

FaceBook Whatsapp Twitter