In MySql there is no provision to write trigger to update multiple row. if u want to update multiple row at a time throughtrigger then write sp and call it from trigger;if ur SP will not work for this then call ur stored procedure at specific time interval.jai singh

This thread is locked for new responses. Please post your comments and questions as a separate thread.If required, refer to the URL of this page in your new post.