How to copy column data to another column only if field is Null in MySql?
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
1650 views
1 Answers
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
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 = ''
1650 views
Answered