mysql copy entire column to a new one

what is the sql sentence to copy a column to the a new coloumn?
I want to create a copy of a column
LVL 1
BRMarketingAsked:
Who is Participating?
 
Ryan ChongCommented:
for example:
ALTER TABLE yourTable ADD newCol VARCHAR(250);

Open in new window

then:
Update yourTable Set newCol = oldCol;

Open in new window

0
 
Ryan ChongCommented:
>>what is the sql sentence to copy a column to the a new coloumn?
>>I want to create a copy of a column

ceate a new column first and then use an update query.
0
 
BRMarketingAuthor Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.