MySQL语句之describe，explain，help，use

1 创建测试表及数据

create table utility_table(  
    c1 int not null auto_increment,   
    c2 varchar(10),   
    c3 int(10),   
    primary key(c1)  
)engine=innodb;  
insert into utility_table values('', 'name1', 001);  
insert into utility_table values('', 'name2', 002);  
insert into utility_table values('', 'name3', 003);  
insert into utility_table values('', 'name4', 004);  
insert into utility_table values('', 'name5', 005);

2 DESCRIBE，DESC，EXPLAIN语句

    DESCRIBE,DESC与EXPLAIN是同义词，它门是SHOW COLUMNS FROM的快捷方式，DESCRIBE语句被设立出来，用于与Oracle相兼容。语句给出了有关表的列信息。

    基本语法：

{EXPLAIN | DESCRIBE | DESC}
    tbl_name [col_name | wild]

{EXPLAIN | DESCRIBE | DESC}
    [explain_type]
    explainable_stmt

explain_type: {
    EXTENDED
  | PARTITIONS
}
explainable_stmt: {
    SELECT statement
  | DELETE statement
  | INSERT statement
  | REPLACE statement
  | UPDATE statement
}

    实例：

mysql> describe utility_table;
mysql> desc utility_table;