Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k points)

Is it possible to copy data from column A to column B for all records in a table in SQL?

1 Answer

0 votes
by (40.7k points)

Use this code:

UPDATE table SET columnB = columnA;

This will be useful to update every row.

Related questions

0 votes
1 answer
asked Dec 26, 2020 in SQL by Appu (6.1k points)
0 votes
1 answer
asked Jul 19, 2019 in SQL by Tech4ever (20.3k points)

Browse Categories