MySQL - copy data from one column to another in the same table

Posted on 2007-07-24
Last Modified: 2012-06-22
I have a table as shown below, how can I copy the contents from itemName to itemDescb
I need to copy from one column to another column in the same table.

CREATE TABLE `products` (
  `PID` int(11) NOT NULL auto_increment,
  `prodcode` varchar(10) default NULL,
  `cat` varchar(40) NOT NULL default '',
  `subcat` varchar(40) default NULL,
  `itemName` varchar(50) default NULL,
  `itemDesc` text,
  `itemDescb` varchar(40) default NULL,
  `itemPrice` decimal(6,2) default '0.00',
  `special` decimal(6,2) default NULL,
  UNIQUE KEY `id` (`PID`)

Thanks in advance for your help.
Question by:sabecs
    LVL 35

    Accepted Solution

    update products set itemDescb = itemName

    Author Comment

    Thanks Raynard7.
    LVL 35

    Expert Comment

    no worries - glad to help

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
    Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API ( …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now