minte9
LearnRemember / MYSQL



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: 688 days ago




Questions and answers




Get table structure:

  • a) SHOW CREATE TABLE mytable
  • b) GET CREATE TABLE mytable


References