delete from sea_data where v_id in (select v_id from (select v_id from sea_data where v_name in 
(select v_name from sea_data group by v_name having count(v_name)>1) and v_id not in
(select min(v_id) from sea_data group by v_name having count(v_name)>1)) as tmpresult)

affected rows:38761 （找到同名影片的数量）
时间：3.264s （处理数据时间）

然后，使用Navicat连接mysql数据库，右键选择“sea_data”–>设计表，打开“索引”

最后，将”idx_name”索引类型修改为“UNIQUE”，并添加字段“v_enname”，点击左上角“保存”mysql数据库即可。