Solved

copy data from one column to another column of table, pl/sql

Posted on 2008-10-06
5
4,623 Views
Last Modified: 2013-12-07
i have 6 columns in the table.
i have to write a sql query to copy data of 1 columns in the another column of the database.any help appreciated.. am using mysql
0
Comment
Question by:sakvk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 15

Accepted Solution

by:
Shaju Kumbalath earned 250 total points
ID: 22656983
if u want to update col2 with col1
update <table_name>  set col2 =col1;
 
0
 
LVL 4

Assisted Solution

by:Finec
Finec earned 250 total points
ID: 22657007
This code will update you row's one_column to this rows's other_column, where your id is 'yourid'.
UPDATE table_name SET one_column=other_column WHERE id=yourid

Open in new window

0
 

Author Comment

by:sakvk
ID: 22672610
thanku
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

630 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