在update user set host='%' where user='root之后,我失去了MySQL根用户的一些特权。所以我停止了服务器,用跳过的授权表启动它。msqld --skip-grant-tablesmysql>updatemysql.user set grant_priv = 'Y' where user = 'root';
QueryOK, 0 rows affected (0.
我想要在update record之后更新一列"status“,并且仅当四个特定列不为null时才更新。这是我的触发器,但它不能正常工作。CREATE TRIGGER `after_thesis_rate_upade`FOR EACH ROW IF (new.promoterRatenew.promoterNote IS NOT NULL AND new.reviewerNote IS NOT NULL AND new.reviewerRate IS NOT NULL)
TH