苹果cms删除数据库重复数据,后台或数据库运行以下语句即可。注意记得备份。
| 1 | DELETE FROM {pre}vodwhere vod_id not in ( SELECT vod_id FROM {pre}vodGROUP BY vod_name HAVING COUNT (*)>1) |

苹果cms删除数据库重复数据,后台或数据库运行以下语句即可。注意记得备份。
| 1 | DELETE FROM {pre}vodwhere vod_id not in ( SELECT vod_id FROM {pre}vodGROUP BY vod_name HAVING COUNT (*)>1) |
文章版权声明:除非注明,否则均为本站原创文章,转载或复制请以超链接形式并注明出处