苹果cms常用sql语句-删除数据库名称重复的数据
					
						时间2024-10-17 14:31:22浏览208
					
					
						导读:[color=rgba(58, 58, 58, 0.88 ]  删除数据库名称重复的数据     [color=rgba(58, 58, 58, 0.88 ]       DELETE FROM{pre}vodwhere vod_id not in(SELECT vod_id FROM{pre}vodGROUP BY vod_name HAVING COUN...
[color=rgba(58, 58, 58, 0.88)] 
删除数据库名称重复的数据 
 
 [color=rgba(58, 58, 58, 0.88)] 
  
 
DELETE FROM{pre}vodwhere vod_id not in(SELECT vod_id FROM{pre}vodGROUP BY vod_name HAVING COUNT(*)>1)