Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-06
5
Medium Priority
?
4,632 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
3 Comments
 
LVL 15

Accepted Solution

by:
Shaju Kumbalath earned 1000 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 1000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

772 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