Yes I did,

I put the END and tried but it is same as before.

Hi Group,

I have a small Query regarding calling a procedure from a trigger
please go through the following and please let me knwo if any thing wrong happened.


DELIMITER $$

DROP...

Well,

Thanks for the early reply

But my issue is slightly different say a user has registred ie.. a new row is updated in User table ,in the user table there is a feild Message I simply want...

Hi Group ,

A small Query ,I need to know how can I notify a new row entry in a table.

to be more specific I have a table Users If at all a new users registers from web his details are stored in...

Hi, Thanks fo rthe reply right now I odnt have nay problem with my statements..

yes u r right mysql.event is available for 5.1.6 or gretaer than that

I wrote a procedure schedule() in that proc...

>>select into

I think it is used in SQL Server.
is it possible in Mysql?

Hi,

Sorry For the delayed reply.

The functionality db of my appplication is around two tables
both of different structures.

Table1:Schedule
Table2:Out

Hi

Thanks for the reply ...I wrote a procedure which copies the data from one table to other but no idea regarding when and where it should be invoked in order to tansfer at the given timestamp.

Hii Group,

This is samuel Like to hav a small suggestion from you hope u ppl do.
"I would like to copy dat from one table to another of the same database in a give
timestamp,I mean...