Mysql 查询操作--表

1.查询所有的表

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test';

2.查询表结构和注释

select  column_name, column_comment from information_schema.columns where table_schema ='test'  and table_name = 't_user_copy'