复制表内容

场景，张三有一堆权限，复制张三的权限给李四

INSERT INTO "dlpt_dm"."t20_measure_authorization_group" ( "measure_authorization_group_id", "measure_dim_combination_id", "group_id", "creation_time", "update_time", "creator_id", "modifier_id", "measure_type", "due_time" ) SELECT REPLACE
( CAST ( uuid_generate_v4 ( ) AS VARCHAR ), '-', '' ),
"measure_dim_combination_id",
'b162453532d54777bb654b3691ab04d5',
"creation_time",
"update_time",
"creator_id",
"modifier_id",
"measure_type",
"due_time" 
FROM
    dlpt_dm.t20_measure_authorization_group 
WHERE
    group_id = 'b42c03ad9ba0431c9747f74e65656272'