转自: https://blog.csdn.net/u014229742/article/details/82109283
#检测foodname是否重复
select foodname,count(*) as count from tablename group by foodname having count>1;
转自: https://blog.csdn.net/u014229742/article/details/82109283
#检测foodname是否重复
select foodname,count(*) as count from tablename group by foodname having count>1;