newbie. :) )
-Deanna
----- Original Message -----
From: "Ryan Mitchell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 08, 2003 8:05 AM
Subject: Re: copy record in mysql
Mysql syntax says you cant insert into the table you select from, unless I
read it wrong.
On 8/12/03 2:00 pm, "Deanna Schneider" <[EMAIL PROTECTED]>
wrote:
> Um, you mean:
> Insert into mytable
> select * from mytable where someclause that gets your old column?
>
> ----- Original Message -----
> From: "Ryan Mitchell" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, December 08, 2003 7:53 AM
> Subject: OT: copy record in mysql
>
> Hello
>
> I google'd this but couldn�t get an answer.
>
> I have a table with lots of columns of different types. I need to copy a
row
> to a new row... How would you do this? Preferable in mysql without
> coldfusion... But if that�s not possible, a coldfusion solution will do
> fine.
>
> Thanks,
> Ryan
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
