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;

 

posted @ 2017-09-14 15:43  雨花梦  阅读(720)  评论(0编辑  收藏  举报