You could accomplish this with a trigger on the table - on INSERT, execute a DELETE statement. http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
You would need to find a way to identify which is the "bottom" record to be deleted ... I might use an ID column, and consider the lowest-numbered row as the "bottom" one. You might also need to include a condition so that it does not start deleting records until you've reached the appropriate number of records in the table, or if your database is slow-moving, you could simply create the trigger once you have the appropriate number. HTH, Dan On 8/29/06, Tanner Postert <[EMAIL PROTECTED]> wrote:
sorry for the double post. if i want to have a row of about 100 records. and everytime i insert a new record, it gets pushed on the top, and the bottom one gets pushed out, sort of like a heap. is this possible? i know i can just delete the record, etc, but i was wondering if there was a built in way of doing it. T
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]