• Teach Your Self With
             w3htmlschool.com

Mysql Create Table

Mysql table store the data infrom of row and column.
Mysql table is identified by unique name.

Mysql Table options are
–ENGINE
–COMMENT –CHARACTER SET
–COLLATE

Column Options
--NULL -- DEFAULT
--NOT NULL -- AUTO_INCREMENT

Example
MySQL Create table
This command will create the database as shown in the example
mysql> CREATE TABLE CountryL (
-> CCode CHAR(3) NOT NULL,
-> Language CHAR(30) NOT NULL,
-> IsOfficial ENUM('True', 'False') NOT NULL DEFAULT 'False',
-> Percentage FLOAT(3,1) NOT NULL,
-> PRIMARY KEY(CCode, Language)
-> )ENGINE = MyISAM COMMENT='Lists Language Spoken';
Query OK, 0 rows affected (0.20 sec)