MySQL Create Table
Here, you will read the brief description about the MySQL create table. The
CREATE TABLE statement is used for creating a table in database.
There are following way to create MySQL table:
Syntax:
| CREATE TABLE tablename(column1name type, column1name
type,.........); |
This is a basic CREATE TABLE statement
that should work in any sql database.
Query:
| CREATE TABLE table_example(id int, name varchar(50),description varchar(200)); |
If you want to know about the created table then you write the following
query:
Query:
Output:
To create a table with a particular storage engine:
If you create table without specifying the ENGINE option then server will use
the default storage engine MyISAM. If you want to use other, storage types must be
defined.
Query:
| CREATE TABLE table_example1(id int, name varchar(50),description
varchar(200))ENGINE=innodb; |
ENGINE=innodb is the method of defining the storage type.
Execute the Query "DESC table_example1;" to see the table
structure:
Output:
To create a table with auto-increment: If you use auto-increment then
you will be able to automatically assign the value to a specified column. The
auto-increment property should not be null. In the table created from the
query below, the data in the "id" column will be added automatically
if not specified.
Query:
| CREATE TABLE table_example2(id int NOT NULL AUTO_INCREMENT PRIMARY KEY, stuName varchar(50)); |
Execute the Query "DESC table_example2;" to see the table structure:
Output:
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
