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
Qmail List" <[EMAIL PROTECTED]>
Cc: <[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:
>
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
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
