mysql设置表自动生成UUID

create trigger id_trigger
before insert on student_excel
for each row
begin
    set new.id=replace(UUID(),'-','');
end

创建触发器

posted @ 2021-10-15 14:10  java璀璨小菜鸟  阅读(704)  评论(0)    收藏  举报