MySQL view information such as self-increment ID and table DDL

MySQL view information such as self-increment ID and table DDL Technology

Maybe yes posted on 2015-01-24 21:50

Original link: http://blog.lmlphp.com/archives/69 from: lmlphp backyard

MySQL View database table related information and the self-increment ID method is as follows:

Method One

Mysql> Show CREATE TABLE table_name\g;*************************** 1. Row *************************** table:table_namecreate table:create Table ' table_name ' (' ID ' int (one) unsigned NO T null auto_increment, ' ArticleID ' int (one) unsigned not NULL, ' abstract ' text is not null, ' content ' text is not NULL, PRIMA RY key (' ID '), key ' ArticleID ' (' ArticleID ')) Engine=myisam auto_increment=8408 DEFAULT charset=utf81 row in set (0.09 SE c) Error:no query specified

Method Two

mysql> show table status like  ' table_name ' \g;*************************** 1.  row ***************************            name: table_name         engine: myisam         version: 10     row_format: dynamic            Rows: 8407 Avg_row_length:  4807    data_length: 40417952max_data_length: 281474976710655    index_length: 177152      data_free: 0 auto_increment: 8408     Create_time: 2015-01-24 13:28:48    Update_time:  2015-01-24 13:30:50     check_time: 2015-01-24 13:30:50       collatiOn: utf8_general_ci       checksum: null create_options:         Comment:1 row in set  (0.56 sec) ERROR: No query specified

Read (64) reviews (0) View comments

MySQL view information such as self-increment ID and table DDL