copy all values of a column to another column in sql in same table
UPDATE table SET columnB = columnA;
copy all values of a column to another column in sql in same table
UPDATE table SET columnB = columnA;
sql query to copy data from one column to another
UPDATE table_name SET
destination_column_name=orig_column_name
WHERE condition_if_necessary
copy data from one table column to another table column in sql
#to copy or update a table column from another table column
UPDATE table_name1
SET column1 = (
SELECT column2
FROM table_name2
WHERE table_name1.id = table_name2.id
);
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us