Show Syntax to Recreate a MySQL Table
Posted:
Friday, May 1st, 2015Last modified:
Friday, May 1st, 2015Topics:
MySQLShow the CREATE TABLE Statement Required to Recreate a Table Schema
mysql> SHOW CREATE TABLE variable\G *************************** 1. row *************************** Table: variable Create Table: CREATE TABLE `variable` ( `name` varchar(128) NOT NULL DEFAULT '' COMMENT 'The name of the variable.', `value` longblob NOT NULL COMMENT 'The value of the variable.', PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='A long comment...' 1 row in set (0.00 sec)
Available Wiki Topics
The operator of this site makes no claims, promises, or guarantees of the accuracy, completeness, originality, uniqueness, or even general adequacy of the contents herein and expressly disclaims liability for errors and omissions in the contents of this website.