mysql - 如何将此触发器转换为我的 sql，这仅适用于 ms sql

Question

create table Items
(
        Number BIGINT PRIMARY KEY IDENTITY,
        ItemNumber VARCHAR(100),
        ItemName varchar(50),
        ItemDescription varchar(50),
        Category varchar(50),
        CreatedDate datetime ,
        Suppiler varchar(50),
        MinOrderQty int,
        unit varchar(50),

)

这是我的表 Items 的触发器:

CREATE TRIGGER loadprefix
ON Items
FOR INSERT 
AS 
  BEGIN 
      UPDATE Items 
      SET    ItemNumber = 'ITEM-' + CONVERT(VARCHAR, (SELECT Number FROM inserted)) 
      WHERE  Number = (SELECT Number 
                   FROM   inserted) 
  END

Answer 1

如果我理解正确的话，这将 ItemNumber 定义为带有前缀的 Number 。这是一种方法:

DELIMITER $$

CREATE TRIGGER loadprefix BEFORE INSERT ON items 
FOR EACH ROW
BEGIN
    NEW.ItemNumber = CONCAT('ITEM-', NEW.Number)
END;
$$
DELIMITER ;