Mega Code Archive

 

Categories / MySQL Tutorial / Table

 

SHOW CREATE TABLE displays the CREATE TABLE statement to create a given table

mysql> mysql> CREATE TABLE myTable     -> (     ->     c1 CHAR(10)     -> ) DEFAULT CHARACTER SET latin1 COLLATE latin1_danish_ci; Query OK, 0 rows affected (0.05 sec) mysql> mysql> desc myTable; +-------+----------+------+-----+---------+-------+ | Field | Type     | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | c1    | char(10) | YES  |     | NULL    |       | +-------+----------+------+-----+---------+-------+ 1 row in set (0.00 sec) mysql> mysql> SHOW CREATE TABLE myTable; +---------+------------------------------------------------------------------------------------------------------------------------------------------------+ | Table   | Create Table                                                                                                                                   | +---------+------------------------------------------------------------------------------------------------------------------------------------------------+ | myTable | CREATE TABLE `mytable` (   `c1` char(10) collate latin1_danish_ci default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci | +---------+------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> mysql> drop table myTable; Query OK, 0 rows affected (0.00 sec) mysql>