--------mysql stroage engines------------------------
myisam 邮件服务器 聊天记录

innodb  事物外键

ndb 高可用

memory

archive
...

查看表的定义
mysql> show table status like 't' \G;
*************************** 1. row ***************************
           Name: t
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 4995
 Avg_row_length: 39
    Data_length: 196608
Max_data_length: 0
   Index_length: 0
      Data_free: 19922944
 Auto_increment: NULL
    Create_time: 2013-11-27 18:34:21
    Update_time: NULL
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options:
        Comment:
1 row in set (0.00 sec)

ERROR:
No query specified

mysql> show create table t \G;
*************************** 1. row ***************************
       Table: t
Create Table: CREATE TABLE `t` (
  `id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

ERROR:
No query specified

mysql> select * from information_schema.tables where table_name='T' and table_s
hema='TEST' \G;
*************************** 1. row ***************************
  TABLE_CATALOG: def
   TABLE_SCHEMA: test
     TABLE_NAME: t
     TABLE_TYPE: BASE TABLE
         ENGINE: InnoDB
        VERSION: 10
     ROW_FORMAT: Compact
     TABLE_ROWS: 4995
 AVG_ROW_LENGTH: 39
    DATA_LENGTH: 196608
MAX_DATA_LENGTH: 0
   INDEX_LENGTH: 0
      DATA_FREE: 19922944
 AUTO_INCREMENT: NULL
    CREATE_TIME: 2013-11-27 18:34:21
    UPDATE_TIME: NULL
     CHECK_TIME: NULL
TABLE_COLLATION: utf8_general_ci
       CHECKSUM: NULL
 CREATE_OPTIONS:
  TABLE_COMMENT:
1 row in set (0.00 sec)

ERROR:
No query specified