Alter Trigger Statement.

[dilsatsagin]

Hi all. I have started using sqlyog for 2 weeks. It is a good program.Sometimes i want to creat trigger not code onlyi want to use “on tables right click and click create trigger statement but it is passive AND in mysql is there if Update(“columnname”) statement?.If not how can I find the whether a column changed? Could you help me? Thanks.

[peterlaursen]

I am afraid that I do not understand you.

Quote:

Sometimes i want to creat trigger not code

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

Quote:

AND in mysql is there if Update(“columnname”) statement

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

Quote:

how can I find the whether a column changed

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

[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.

[peterlaursen]

Quote:

I click right on a table and I don't see create trigger(it is inactive not active).

I think I understand now!

The server must by MySQL 5.x. Earlier versions do not support triggers. If you execute “select version()” you will have the exact server version.

In SQLyog if you right-click a table there is a 'Create trigger' option. Also if click the + sign left to the table there is a 'TRIGGERS' folder. And from the context menu of the trigger (if there is any) you can choose between options. But the options are only available when connected to MySQL servers that have this feature.

[dilsatsagin]

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

Thanks..

[peterlaursen]

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!

[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…

[Author]

Posts