开发者

MySQL error code 1017

开发者 https://www.devze.com 2023-03-07 01:44 出处:网络
I\'m creating a trigger on one table to insert after on another table. The trigger query seems to be okay to the best of my knowledge, but I\'m getting the error:

I'm creating a trigger on one table to insert after on another table. The trigger query seems to be okay to the best of my knowledge, but I'm getting the error:

Error Code : 1017

Can't find file: '.\rtasys\@003cozekimessagein@003e.frm' (errno: 22)

My trigger query is:

DELIMITER $$ CREATE
/*开发者_如何学运维[DEFINER = { user | CURRENT_USER }]*/
TRIGGER `rtasys`.`on_insert_ozekimessagein` AFTER INSERT
ON `rtasys`.`<ozekimessagein>`
FOR EACH ROW BEGIN

INSERT INTO ozekimessageout SET ozekimessageout.`receiver`=NEW.sender;
INSERT INTO ozekimessageout SET ozekimessageout.`msg`=NEW.msg;
INSERT INTO ozekimessageout SET ozekimessageout.`status`=NEW.sender;

END$$ DELIMITER ;


MySQL can't find ozekimessageout table definition file (.frm). Try to:

REPAIR TABLE ozekimessageout;

or recreate table ozekimessageout. It's also possible that the file exists but MySQL does not have privieleges to read it. Check that the file rtasys\@003cozekimessagein@003e.frm exists and MySQL has rights to read/write/update it.

0

精彩评论

暂无评论...
验证码 换一张
取 消