Mysql Table Definition - Administration

➟

Last update: 29-10-2021

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

REMEMBERS

Table structure