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]

Reply via email to