INSERT INTO pc_company_certificate_image (
id,
regist_id,
regist_no,
image_type,
image_url,
sort,
company_id,
created_by,
creator_id,
created_at,
updated_by,
modifier_id,
updated_at,
dr
) SELECT
UUID( ),
id,
regist_no,
1,
picture_url,
1,
company_id,
created_by,
creator_id,
created_at,
updated_by,
modifier_id,
updated_at,
dr
FROM
pc_company_certificate
将一张表中指定字段的数据添加到另一张表
最新推荐文章于 2022-09-14 14:07:55 发布