How to copy column data to another column only if field is Null in MySql?

Question

How to copy column data to another column only if field is Null in MySql?

Share with your friends

Talk Doctor Online in Bissoy App

Md Ariful Islam · Answer 1 · Feb 19, 2021 11:13:46

If NULL:

UPDATE table_name
SET empty_column = data_column
WHERE empty_column IS NULL

If it an empty string:

UPDATE table_name
SET empty_column = data_column
WHERE empty_column = ''

If it either:

UPDATE table_name
SET empty_column = data_column
WHERE empty_column IS NULL OR empty_column = ''

How to copy column data to another column only if field is Null in MySql?

1 Answers