Need help with a trigger?

[lagg]

I need to create a trigger for MySQL database table. I want to put a message in one table following the update of another table. The trigger should only operate on each new entry as it arrives. I have found out how to do this on an SQL Server how can I do it in MySQL. The following code is the SQL server:
CREATE TRIGGER autoreply ON table1 FOR INSERT
AS
DECLARE @tel VARCHAR(30)
SELECT TOP 1 @tel=field1 FROM table1 ORDER BY ID DESC
INSERT INTO table2 (field2,field3,field4) VALUES
(@tel,'Thank you for the message','send')
GO

It would be great if you could help

 

[r937]

triggers will arrive in release 5 at the end of 2003

http://www.mysql.com/press/release_2003_05.html

rudy

 

[sleipnir214]

Unfortunately, MySQL does not support triggers. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[lagg]

Have either of you got any suggestions as to how i can achieve this other than triggers?

 

[sleipnir214]

Make sure you perform both operations in your scripting language? Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[lagg]

Im not sure what you mean by that. Is it when using PHP? Im not very familiar with using MySQL actually. I was hoping i could just get the database to perform the operation on its own

 

[sleipnir214]

No for a while yet.

If you are using PHP to access the data on MySQL, yes, make sure that whenever you update the first table in your code, you also update the second table. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!