设置uuid触发器
2020-12-12 本文已影响0人
苍老师的眼泪
CREATE DEFINER=`root`@`localhost` TRIGGER `orders_BEFORE_INSERT` BEFORE INSERT ON `orders` FOR EACH ROW BEGIN
SET NEW.order_number=UUID_SHORT();
END
CREATE DEFINER=`root`@`localhost` TRIGGER `orders_BEFORE_INSERT` BEFORE INSERT ON `orders` FOR EACH ROW BEGIN
SET NEW.order_number=UUID_SHORT();
END