MySQL 查看数据库表相关信息和自增 ID 方法如下:
方法一
mysql> show create table table_name\G;
*************************** 1. row ***************************
Table: table_name
Create Table: CREATE TABLE `table_name` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`articleid` int(11) unsigned NOT NULL,
`abstract` text NOT NULL,
`content` text NOT NULL,
PRIMARY KEY (`id`),
KEY `articleid` (`articleid`)
) ENGINE=MyISAM AUTO_INCREMENT=8408 DEFAULT CHARSET=utf8
1 row in set (0.09 sec)
ERROR:
No query specified
方法二
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: 40417952
Max_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