mysql 获取所有表和字段

获取所有表名：

SELECT table_name FROM information_schema.tables WHERE table_schema='cc' AND table_type='base table';

获取表的所有字段：

SELECT column_name FROM information_schema.columns WHERE table_schema='cc' AND table_name='cj1';