Mysql obtains all table names and field comments of the database. 1. obtains field comments. Java code Select COLUMN_NAME column name. DATA_TYPE field type, COLUMN_COMMENT field comment from INFORMATION_SCHEMA.COLUMNS Where table_name = 'companys' # Table name AND table_schema = 'testhuicard '# Database name AND column_name LIKE 'C _ name' # field name 2. Obtain the table comment out the Select table_name table name in Java code, TABLE_COMMENT table comment from INFORMATION_SCHEMA.TABLES Where table_schema = 'testhuicard '# Database Name AND table_name LIKE 'companys' # table name mysql Manual: 23.1. INFORMATION_SCHEMA table 3. Get the Java code $ tt = mysql_query ("show table status;"); $ table_info = array (); while ($ re = mysql_fetch_array ($ tt, MYSQL_ASSOC) {// $ re ["Comment"], this is the table comment $ table_info [] = $ re ;}...... update auto-increment alter table [Table] members AUTO_INCREMENT = 10000