Hello, I have a simple database schema with a table of log entries that grows quickly. Every month I'd like to break last month's entries off into a new table for that (last) month. I know creating new tables within an existing schema is not recommend database design, but in this case it seems to make sense.
I've used triggers and stroed procedures in Oracle to do this kind of table rotating and it was pretty simple. What I'm considering with MySQL is using Cron and the MySQL client app to select the appropriate date range into an hash, write the hash into a newly created table, and then delete the selected rows from original table. My question is, is this recommended logic, or is there a better way to skin this cat using MySQL? Sincerely, Eric --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
