How to find out the CREATE TABLE statement of a selected table.
The 'SHOW CREATE TABLE' command will show the CREATE TABLE statement of a selected table. It will be very helpful for the database backup actions.
SHOW CREATE TABLE `tablename`
It will return two colomns one is its table name and other is the 'CREATE TABLE' statement.
CREATE TABLE `tablename` (
`id` int(10) NOT NULL,
`title` varchar(256) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Hope this will helpful for someone !
