asmith Posted July 3, 2008 Share Posted July 3, 2008 Hi Is it possible i set a limit for the number of the rows of a table ? Like i set it fir 30. after rows of the table reached 30 , when new rows inserted , it deletes the oldest row and insert the new row. so that it remain alwasy 30 rows but updated. is that possible with only mysql query? Quote Link to comment Share on other sites More sharing options...
fenway Posted July 3, 2008 Share Posted July 3, 2008 Sort of... you can implement a queue using INSERT... ON DUPLICATE KEY UPDATE..., triggers, staging tables, etc. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.