mysql触发器表自动更新_mysql 触发器更新自己表|单表操作
#更新表`m_order`的status_id，#注意要用BEFORE#SQL语句不能用UPDATE，要用SETCREATE TRIGGER `tg_order2order_update` BEFORE UPDATE ON `m_order` FOR EACH ROW BEGINset new.`status_id` = (SELECT `status_id` FROM m_status WHE...
