how to create trigger in MYSQL

Jeyaseelansarc · #1 (**permalink**) 05-08-2007, 05:18 AM

HI,
how to create trigger in MySql using PHP?

write2ashokkumar · #2 (**permalink**) 05-08-2007, 07:00 AM

hi...

"How to create trigger in Mysql?" - Is this your question?

Regards,
S.Ashokkumar

Jeyaseelansarc · #3 (**permalink**) 05-09-2007, 01:23 AM

Hi Ashok,
Is there any possibilty that we have fire triggers in PHP?
Ok. First we have to start with creation of triggers in MySql. Do you have any idea about creating trigger in MySql?

write2ashokkumar · #4 (**permalink**) 05-09-2007, 06:21 AM

hi...

A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table.

To know more about the trigger, reffer the following link.

MySQL AB :: MySQL 5.0 Reference Manual :: 18 Triggers

Regards,
S.Ashokkumar

Jeyaseelansarc · #5 (**permalink**) 05-10-2007, 02:55 AM

hi,
Thanks for your reply. But i think we can execute of creating triggers in PHP script is itself

For example,

$query = "CREATE TRIGGER ins_sum BEFORE INSERT ON account
FOR EACH ROW SET @sum = @sum + NEW.amount;";

mysql_query($query);

is it possible?

Murali · #6 (**permalink**) 07-10-2007, 11:53 PM

PHP Code:

  <?php

// Opening a MYSQL Connection

$vConnection = mysql_connect('Local Host IP', 'UserName', 'Password');

// Executing the Query 

$vQuery = mysql_query("CREATE TRIGGER ins_sum BEFORE INSERT ON account FOR EACH ROW SET @sum = @sum + NEW.amount;END;");

mysql_query($vQuery);

// Closing the Connection

mysql_close($vConnection);

?>

Creating a Trigger is very simple as executing a Query.

I have marked the Syntax error in the Stated Query

$query = "CREATE TRIGGER ins_sum BEFORE INSERT ON account
FOR EACH ROW SET @sum = @sum + NEW.amount;END;";
mysql_query($query);

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Setup a clock with defined alarm times which trigger another event	itbarota	HTML, CSS and Javascript Coding Techniques	1	03-04-2008 09:57 PM
How to create UDF function in Mysql	Murali	Database Support	1	12-01-2007 02:03 AM
Can we have a commit statement inside a trigger? if no why cant we?	Mramesh	Database Support	6	09-11-2007 03:08 AM
Run an exe from an oracle trigger	H2o	Database Support	5	08-09-2007 11:55 AM
Storing the output from trigger in a text file	sureshbabu	Database Support	3	07-27-2007 06:44 AM