#查询不存在的ID
SELECT
id
FROM
1688_tips
WHERE
id NOT IN (
SELECT
tips_id
FROM
1688_tips_option
)
#删除不存在的ID
DELETE
FROM
1688_tips
WHERE
id NOT IN (
SELECT
tips_id
FROM
1688_tips_option
)
mysql 内查询
最新推荐文章于 2024-11-14 20:01:49 发布