PROGRAMMING

 
REMEMBERS




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    

        A B C D E F
🔔
1/1