RE: Moving Data from one table to another table

2004-12-29 Thread Chris Lyon
> -Original Message- > From: Scott Pham [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 28, 2004 12:55 PM > To: Perl Beginners List > Cc: Christopher Lyon > Subject: Re: Moving Data from one table to another table > > Depending on what database platform you a

RE: Moving Data from one table to another table

2004-12-29 Thread Chris Lyon
> -Original Message- > From: Chris Devers [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 28, 2004 12:51 PM > To: Christopher Lyon > Cc: Perl Beginners List > Subject: Re: Moving Data from one table to another table > > On Tue, 28 Dec 2004, Chris Lyon wrote: &

Re: Moving Data from one table to another table

2004-12-29 Thread Scott Pham
Depending on what database platform you are using, you can easily do "SELECT * into new_table from table; On Tue, 28 Dec 2004 15:50:41 -0500 (EST), Chris Devers <[EMAIL PROTECTED]> wrote: > On Tue, 28 Dec 2004, Chris Lyon wrote: > > > So, I am trying to move data from one sql table to another t

Re: Moving Data from one table to another table

2004-12-28 Thread Chris Devers
On Tue, 28 Dec 2004, Chris Lyon wrote: > So, I am trying to move data from one sql table to another table > called logs_archive. It seems that I am running into some problems > with memory as I am moving this much data from one table to another. > This is just syslog data but we need to archive

Moving Data from one table to another table

2004-12-28 Thread Chris Lyon
Maybe this is a little OT but since I am a beginner @ perl, I thought that I would post it! So, I am trying to move data from one sql table to another table called logs_archive. It seems that I am running into some problems with memory as I am moving this much data from one table to another. Th