如果用户表没有证件照,则将注册照作为证件照。
UPDATE smart_park.tb_user
SET identification_pic_id = register_pic1_path
WHERE
register_pic1_path IS NOT NULL
AND
identification_pic_id IS NULL;
如果用户表没有证件照,则将注册照作为证件照。
UPDATE smart_park.tb_user
SET identification_pic_id = register_pic1_path
WHERE
register_pic1_path IS NOT NULL
AND
identification_pic_id IS NULL;