mysql常用sql语句

查询MySQL中某个数据库中有多少张表

SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = '数据库' GROUP BY table_schema;

 

sql怎样实现查找所有，然后对字段去重

select name from table group by name;