I want to duplicate the last record in my table every minute, i'm using php and mysql.
I can use a cronjob to run it every minute, i know how to do that.
But i don't know how to duplicate the last row, i only have an id that auto_increment and value column.
For example :
Id, Value
10, Green
11, Green
12, Green
13, Green
I think select into is what you are looking for.