[dilsatsagin]

peterlaursen wrote on Dec 15 2006, 02:17 PM:

There is no ALTER TRIGGER statement in MySQL.

You do like this: DROP the TRIGGER and CREATE again with the new content.

You will not lose anything (such as data) with that as TRIGGERS do not hold any data themselves.

Do you see the CREATE TRIGGER statement in the table context menu now?

Have you updated the Server in between?

Some screenshots would be nice, so that we can see what you see!

Thanks peterlaursen again…

[dilsatsagin]

And also I can not use ALTER TRIGGER statement. I see error messages. I use mysql 5.0.24a-community-nt

Thanks..

[dilsatsagin]

peterlaursen wrote on Dec 15 2006, 10:36 AM:

I am afraid that I do not understand you.

but a MySQL TRIGGER is code! Code that is stored as part of a table itslef.

I do not understand this either. You are not talking baout PHP (and not MySQL) here?

By querying it, I would say. Did I miss something?

I want to say that I don't use create trigger statement in query analyzer. I click right on a table and I don't see create trigger(it is inactive not active)..

I have never code in PHP. And I start using Mysql for about 2 weeks. I use other databases AND now I want to use MYSQL.

Thanks.

[Author]

Posts