mysql 替换语句 mysql对比表删除不存在id
发布时间：2024-01-02 栏目：建站知识
浏览：
分类：
UPDATE phome_ecms_movie_data_1 SET downpath = REPLACE(downpath, 'abc', '123');
DELETE FROM phome_ecms_movie_data_1 WHERE id NOT IN (SELECT id FROM phome_ecms_movie);
SELECT * FROM phome_ecms_movie_data_1 WHERE playdk="" and id IN (SELECT id FROM phome_ecms_movie WHERE isgood > 6)
DELETE FROM phome_ecms_movie_data_1 WHERE id NOT IN (SELECT id FROM phome_ecms_movie);
SELECT * FROM phome_ecms_movie_data_1 WHERE playdk="" and id IN (SELECT id FROM phome_ecms_movie WHERE isgood > 6)
