UUID自动生成

(uuid,available,createtime)  select left(replace(uuid(), '-', ''),24),1,utc_timestamp()

使用：

insert into organization_has_account (id,available,create_time,update_time,organization_id,account_id,is_admin) select left(replace(uuid(), '-', ''),24),1,utc_timestamp(),utc_timestamp(),'59a9259ecfba6900072322e6','59afbabefbe01d0009e4aef3',0;

 

转载于:https://www.cnblogs.com/yuhuameng/p/7521041.html