Mega Code Archive

 

Categories / MySQL Tutorial / MySQL Utilities

 

SHOW CREATE TABLE statement

mysql> mysql> CREATE TABLE Employee(     ->     id            int,     ->     first_name    VARCHAR(15),     ->     last_name     VARCHAR(15),     ->     start_date    DATE,     ->     end_date      DATE,     ->     salary        FLOAT(8,2),     ->     city          VARCHAR(10),     ->     description   VARCHAR(15)     -> ); Query OK, 0 rows affected (0.02 sec) mysql> mysql> show create table Employee; +----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table    | Create Table                                                                                                                                                                                                                                                                                                                                                     | +----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Employee | CREATE TABLE `employee` (   `id` int(11) default NULL,   `first_name` varchar(15) default NULL,   `last_name` varchar(15) default NULL,   `start_date` date default NULL,   `end_date` date default NULL,   `salary` float(8,2) default NULL,   `city` varchar(10) default NULL,   `description` varchar(15) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +----------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> mysql> drop table Employee; Query OK, 0 rows affected (0.00 sec)