| 1 comments ]

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 ! 

1 comments

domain and hosting said... @ Friday, June 17, 2011 at 8:24:00 AM GMT+1

Already I know this information. I want information, How to rollback the information? My friend said that, it is easy but she forgot it.

Post a Comment

Please put your comments here. your questions, your suggestions, also what went wrong with me.