MySQL hard limit rows number

Forum Moderators: open

Message Too Old, No Replies

MySQL hard limit rows number

JazzFrets

10:25 pm on Feb 26, 2007 (gmt 0)

I have a table that I need to limit its size to 100 rows...

when I insert a new row when I have 100 rows already, I need it to replace to the oldest insertion!

I tried the MAX_ROWS=100 option but it seems that it doesn't work as hard limit but it's used to optimize the partition of the DB. I need an answer as soon as possible please!

Thanks in advance!

LifeinAsia

10:34 pm on Feb 26, 2007 (gmt 0)

My guess is that you have to delete the oldest row first before you can insert another.