摘要：delimiter $DROP FUNCTION IF EXISTS `fun_convert`$CREATE DEFINER=`root`@`%` FUNCTION `fun_convert`(para varchar(255))RETURNS varchar(255) CHARSET gbkBEGIN declare result varchar(255) default ''; declare cnt int default 0; declare i int default 0; declare id BIGINT default 0; set cnt = length( 阅读全文

摘要：select * from(select t.`name` `name`,count(*) count from company t group by t.`name`) aa where aa.count>1; 阅读全文