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
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
: [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 10:49 AM
Subject: Re: General question about rotating growing tables
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
But there would be no way to variably create the newtable table name
correct?
Thx
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Qmail List [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 04, 2002 10:49 AM
Subject: Re: General question about rotating