View Single Post
  #2 (permalink)  
Old 04-25-2008, 06:05 AM
Jeyaseelansarc Jeyaseelansarc is offline
D-Web Genius
 
Join Date: Mar 2007
Location: Chennai
Posts: 1,162
Jeyaseelansarc is on a distinguished road
Send a message via AIM to Jeyaseelansarc
Default Re: Trigger in MySql

So finally i have found something to do with triggers

Code:
DELIMITER $$

CREATE TRIGGER newsCounter
AFTER INSERT ON News
FOR EACH ROW BEGIN
 INSERT INTO NewsCount (newsItemCount) (SELECT count(*) FROM News);
END;
$$
__________________
With,
J. Jeyaseelan

Everything Possible
Reply With Quote