mysqlÈ¡µÃÊý¾Ý¿âËùÓбíÃûºÍ×Ö¶Î×¢ÊÍ

1¡¢È¡×Ö¶Î×¢ÊÍ
Select COLUMN_NAME ÁÐÃû, DATA_TYPE ×Ö¶ÎÀàÐÍ, COLUMN_COMMENT ×Ö¶Î×¢ÊÍ
from INFORMATION_SCHEMA.COLUMNS
Where table_name = 'companies'##±íÃû
AND table_schema = 'testhuicard'##Êý¾Ý¿âÃû
AND column_name LIKE 'c_name'##×Ö¶ÎÃû
2¡¢È¡µÃ±í×¢ÊÍ
Select table_name ±íÃû,TABLE_COMMENT ±í×¢ÊÍ from INFORMATION_SCHEMA.TABLES Where table_schema = 'testhuicard' ##Êý¾Ý¿âÃû
AND table_name LIKE 'companies'##±íÃû
²Î¿¼http://dev.mysql.com/doc/refman/5.1/zh/information-schema.html.
mysqlÊֲ᣺23.1. INFORMATION_SCHEMA±í
3¡¢È¡µÃijÊý¾Ý¿âÏÂËùÓбíµÄ×¢ÊÍ
       $tt = mysql_query("show table status;");
       $table_info£½array();
       while($re = mysql_fetch_array($tt,MYSQL_ASSOC)){
                        //$re["Comment"],Õâ¸ö¾ÍÊDZíµÄ×¢ÊÍ
                        $table_info[] = $re;
        } ......
¸üÐÂ×ÔÔöÖµ ALTER TABLE [Table]members AUTO_INCREMENT=10000