http://jackxiang.com/index.php zh-cn http://jackxiang.com/post/4978/ jack <xdy108@126.com> Tue, 14 Feb 2012 03:56:40 +0000 http://jackxiang.com/post/4978/ select * from information_schema.tables where table_schema='dbname' and table_name ='tbname'; select * from mysql.proc where db='dbname' and name='procname';
mysql> show table status where name ='user'\G; *************************** 1. row ***************************            Name: user          Engine: MyISAM         Version: 10      Row_format: Dynamic            Rows: 32 Avg_row_length: 79     Data_length: 2556 Max_data_length: 281474976710655    Index_length: 2048       Data_free: 0 Auto_increment: NULL     Create_time: 2010-01-05 15:13:32     Update_time: 2012-01-04 11:35:51      Check_time: NULL       Collation: utf8_bin        Checksum: NULL Create_options:         Comment: Users and global privileges 1 row in set (0.00 sec)
select CREATE_TIME from INFORMATION_SCHEMA.TABLES where TABLE_NAME='table1'
show table status;
show table status where name ='表名'; 可以查看指定表的信息
show table status where name ='t_tst_draft_info';
]]> http://jackxiang.com/post/4978/#blogcomment63479 hxngb7af <ggzm55@mail114.net> Sun, 19 Feb 2012 03:17:30 +0000 http://jackxiang.com/post/4978/#blogcomment63479 http://jackxiang.com/post/4978/#blogcomment63615 mark28347 <prettyall@126.com> Thu, 23 Feb 2012 04:50:25 +0000 http://jackxiang.com/post/4978/#blogcomment63615