Copy content from one column to another

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Copy content from one column to another

Author

Topic

77777778
Starting Member

1 Post

Posted - 2011-12-11 : 04:16:54

Hi there! I have a MySQL DB about jewelry in Magento,

I uploaded it with "short_description" field empty on purpose, but then the "add to basket button" is not shown in particular products.

I would like to know a SQL query to copy "description" content to "short_description" per each product,

Thanks in advance!!

Ann Lee

Epic sax girl

sunnyleoneo
Starting Member

19 Posts

Posted - 2011-12-11 : 05:51:19

Please post your both table structure. This will help us to write exact query.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-11 : 11:11:39

I think you're in wrong forum
This is MS SQL Server forum and people here have not enough skillset in other RDBMS like MySQL

Anyways, as per standard ANSI standard, the update will be like below


UPDATE tablename 
SET short_description=description
WHERE short_description=''

if above is not working, please try you luck at www.dbforums.com

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources