Welcome to TheCredence.com - You may like to subscribe to our RSS feed to stay updated.
Well I wanted to copy one column to another column in mysql and wasn't sure what query to perform. Thankfully MySQL IRC came to the rescue again. Just run this query -
UPDATE table_name SET column1 = column2;
WHere Column1 is the column where you want to copy the data and column2 is from where you want to copy the data. It is pretty obvious like in algebra, x=2 
Also if you want to use mysql IRC, than install this software xchat and connect to #mysql. You can find great ppl there at MySQL IRC.
(No Ratings Yet)
Loading ...Links you may find interesting -