How about Create newtable select * from oldtable where conditions_are_met;
Qmail List wrote:
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
--------------------------------------------------------------------- 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
