MySQL 把一张表中的数据插入另一张表中 insert

2019独角兽企业重金招聘Python工程师标准>>>

insert into t_vital_user_role(id,user_id,role_id,target_id)

SELECT
    REPLACE(UUID(),'-','') AS id, u.id user_id, "3d43e11553d145be930df2e8a6fc5288" role_id, "eeeeefd91e0c11e6866500ff5d77254e" target_id
FROM
    t_vital_user u
LEFT JOIN (
    SELECT
        *
    FROM
        t_vital_user_role
    WHERE
        role_id = '3d43e11553d145be930df2e8a6fc5288'
) r ON u.id = r.user_id
WHERE
    r.user_id IS NULL

转载于:https://my.oschina.net/u/2351011/blog/1821242