Table structure
Show create table displays table fields and structure.
<span class='keyword_code'>SHOW CREATE</span> TABLE tbl_name;
Displays:
<span class='keyword_code'>CREATE TABLE</span> `article` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
http://dev.mysql.com/doc/refman/5.0/en/show-create-table.html
Last update: 221 days ago