开发者

MYSQL trigger gets deleted automatically

开发者 https://www.devze.com 2023-01-02 03:02 出处:网络
I have using mysql 5.1 with cpanel /whm centOS. I had to use trigger for one of my website. so i installed trigger as root so that when something gets inserted on one table there some more rows gets

I have using mysql 5.1 with cpanel /whm centOS.

I had to use trigger for one of my website. so i installed trigger as root so that when something gets inserted on one table there some more rows gets inserted in other table

Everything was working fine, but 开发者_运维知识库i have seen that there is no trigger in my dtabase.

How does that be deleted from DB.

I am bit worried because currently site is not live , but it can cause problem if this happens in live site.

Does any mysql updation cause the trigger to delete. but i have no updated.

How can i make sure it don't happen in future

Thanks


Did you try:

SHOW TRIGGERS;
0

精彩评论

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