DO
$$
DECLARE
tmp RECORD;
BEGIN
FOR tmp IN select distinct id from test LOOP
INSERT INTO test1 (id,role_code,privilege_code,space_id) VALUES
(FLOOR(random() * 2147483646),'COMMON_USER','test',tmp.space_id);
END LOOP;
END
$$
;
posted on
2023-06-14 22:24张释文
阅读(281)
评论(0)
编辑收藏举报