Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages

CREATE TABLE


The MySQL CREATE TABLE command is used to create a new table into the database. A table creation command requires three things:

  • Name of the table
  • Names of fields
  • Definitions for each field

Syntax:

Following is a generic syntax for creating a MySQL table in the database.

  1. CREATE TABLE table_name (column_name column_type…);

Example:

Here, we will create a table named “cus_tbl” in the database “customers”.

  1. CREATE TABLE cus_tbl(
  2.    cus_id INT NOT NULL AUTO_INCREMENT,
  3.    cus_firstname VARCHAR(100) NOT NULL,
  4.    cus_surname VARCHAR(100) NOT NULL,
  5.    PRIMARY KEY ( cus_id )
  6. );

Note:

  1. Here, NOT NULL is a field attribute and it is used because we don’t want this field to be NULL. If you will try to create a record with NULL value, then MySQL will raise an error.
  2. The field attribute AUTO_INCREMENT specifies MySQL to go ahead and add the next available number to the id field.PRIMARY KEY is used to define a column as primary key. You can use multiple columns separated by comma to define a primary key.

Visual representation of creating a MySQL table:

createtable

See the created table:

Use the following command to see the table already created:

  1. SHOW tables;

showtable

See the table structure:

Use the following command to see the table already created:

  1. DESCRIBE cus_tbl;

describetable

 

Comments

comments