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