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? Link to comment https://forums.phpfreaks.com/topic/113049-set-a-limit-for-inserting-rows/ 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. Link to comment https://forums.phpfreaks.com/topic/113049-set-a-limit-for-inserting-rows/#findComment-580776 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.