freelanceprogrammers.org Forum Index » Cold Fusion
copy table to another table
Joined: 25 Apr 2005
Posts: 6
copy table to another table
hi, i`m using coldfusion with mysql. my question is how do i make an
archive from certain table. i`m thinking on certain date, it will
automatically create a new table and it will copy all the data and put
it in a new table. Got any idea?
Joined: 25 Apr 2005
Posts: 10
copy table to another table
> hi, i`m using coldfusion with mysql. my question is how do i make an
> archive from certain table. i`m thinking on certain date, it will
> automatically create a new table and it will copy all the data and put
> it in a new table. Got any idea?
There are much better ways of doing this outside of CF but you could
simply write a page that would perform the functions you`re wanting to
do.
Joined: 25 Apr 2005
Posts: 6
copy table to another table
yeah....but i`m still doesn`t know the command to copy the whole data
to another table
> There are much better ways of doing this outside of CF but you could
> simply write a page that would perform the functions you`re wanting
to
> do.
Joined: 02 Apr 2005
Posts: 20
copy table to another table
Check if MySQL supports "Select Into".
Mark Gregory
----- Original Message -----
From: "arinpsycho" <arinpsycho@...>
To: <cold_fusion@yahoogroups.com>
Sent: Monday, April 25, 2005 12:12 AM
Subject: [cold_fusion] Re: copy table to another table
>
>
> yeah....but i`m still doesn`t know the command to copy the whole data
> to another table
>
> > There are much better ways of doing this outside of CF but you could
> > simply write a page that would perform the functions you`re wanting
> to
> > do.
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
Joined: 25 Apr 2005
Posts: 10
copy table to another table
If you were using MSSQL I would recommend a simple SELECT INTO, MySQL
doesn`t support it the same way.
Your best bet is to do an INSERT INTO newTable (fields)
SELECT (fields)
FROM OldTable
You`ll need to add more in there for cleanups and duplicate avoidance.
Hatton
On 4/25/05, arinpsycho <arinpsycho@...> wrote:
>
>
> yeah....but i`m still doesn`t know the command to copy the whole data
> to another table
>
> > There are much better ways of doing this outside of CF but you could
> > simply write a page that would perform the functions you`re wanting
> to
> > do.
>
> Yahoo! Groups Links
>
>
>
>
>
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
China Wholesale - Electronics Products
Character Studio - Tutorials and Help