How to merge columns?

Question

MySQL

spoiler

You need to merge into a date column, then delete data.

Answer 1

Copy data to date field Delete data column:
UPDATE tbl_name SET date = data WHERE date IS NULL
ALTER TABLE tbl_name DROP COLUMN data;