删除已不存在的profileId(pro表)的profile_grows表中的记录:
DELETE FROM `profile_grows` pcgw
WHERE NOT EXISTS (SELECT id FROM `pro` p WHERE p.`profileId` = pcgw.`profileId`)
删除已不存在的profileId(pro表)的profile_grows表中的记录:
DELETE FROM `profile_grows` pcgw
WHERE NOT EXISTS (SELECT id FROM `pro` p WHERE p.`profileId` = pcgw.`profileId`)