insert into tb_target(id,employeeId,January,February,createUser,createDate,del)
select MD5(UUID()),id,50000.00,50000.00,'admin',now(),del from tb_test where del = 1
insert into 用法
于 2022-07-22 11:38:25 首次发布
insert into tb_target(id,employeeId,January,February,createUser,createDate,del)
select MD5(UUID()),id,50000.00,50000.00,'admin',now(),del from tb_test where del = 1