minte9
LearnRemember   MYSQL





Table structure

Show create table displays table fields and structure. 
 
SHOW CREATE TABLE tbl_name;
Displays: 
 
CREATE TABLE `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





Questions and answers:
Clink on Option to Answer




1. Get table structure:

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


References: