limiting the number of registers

[router]

Last Thread Next Thread

  Author
                                 Thread








  router
  Member

  Registered: Dec 2002
  Location: 
  Posts: 79
                                    limit the number of register 

Hello!!
I need to limit the number of register that there is in a table.
Before closing my aplicattion i check if the number of register of my table t1 is minor than MAX. If the number is greater i delete the oldest data until the number will be MAX (FIFO, first in first out). So i will never have more than MAX register in this table t1 finally.
How can i limit the number of register in a table?
I use mysql, Is it possible using any function of mysql?
Any idea? Is it possible?
Thanks in advance
Router