View last inserted rows

[aarushi2001]

Hi,

I am bit confused. I have a table, which is being populated based on number of judges. So if there are 3 judges, 3 rows are inserted with values. (no problem)

My task is:
I want to extract id of these rows (cud be one or more) and then insert them into a new table.

Is it possible?

Thanks

 

[johnwm]

Looks like a job for a Trigger - see:

http://dev.mysql.com/doc/refman/5.1/en/triggers.html

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[aarushi2001]

yup.. thanks .. really helpful..