我需要更新一个DB,其中有错误。
我已经创建并导入了包含所有正确字段的第二个表。这条语句比较了两个表中有错误的col,返回所有is_councils = Y:
SELECT users_base.first_name, users_base.is_councilor,
users_base.email,
users_bk2.is_councilor
FROM users_base
INNER JOIN users_bk2
ON users_base.first_name=users_bk2.first_name AND users_base.email = users_bk2.email
WHERE users_bk2.is_councilor = 'Y';
我的问题:更新users_base的insert/update语句是什么?WHERE users_bk2. is_council . is_council . is_council . is = 1is_advisor是'Y'的值,现在我正在生成这个列表?
试一下
UPDATE users_base ub
INNER JOIN users_bk2 ub2
ON ub.first_name=ub2.first_name
AND ub.email = ub2.email
SET ub.is_councilor = '1'
WHERE ub2.is_councilor = 'Y'