CREATE TRIGGER format_goods_sn
BEFORE INSERT ON tp_goods
FOR EACH ROW
BEGIN
  SET NEW.goods_sn = CONCAT('TP', LPAD(NEW.goods_id, 7, '0'))
END