mysql数据库所有表名及所有表的字段写入表中

数据库所有表名写入表中

INSERT INTO test.table ( test.table.`name`, test.table.`describe` ) SELECT
TABLE_NAME,
TABLE_COMMENT 
FROM
	INFORMATION_SCHEMA.TABLES 
WHERE
	table_schema = 'test';

数据库所有表的字段写入表中

INSERT into test.table_field(test.table_field.table_id,test.table_field.field_name, test.table_field.field_type)
SELECT
	t.id,
	c.column_name,
	c.DATA_TYPE
FROM
	information_schema.COLUMNS as c right JOIN test.table as t on c.TABLE_NAME = t.`name`
WHERE
	c.table_schema = 'test';