查询表名为member的表,以id为条件,以name分组查询重复数据
SELECT * FROM member where id='12102' GROUP BY name having count(*) > 1
查询表名为member的表并根据table_name以汉字首字母排序 SELECT * FROM member ORDER BY CONVERT(table_name USING gbk)
查询表名为member的表,以id为条件,以name分组查询重复数据
SELECT * FROM member where id='12102' GROUP BY name having count(*) > 1
查询表名为member的表并根据table_name以汉字首字母排序 SELECT * FROM member ORDER BY CONVERT(table_name USING gbk)