hi,
I am a bit confused, should I delete a column as the data in that col is not in use in the system or make it null so that the old data remains.
what's the better approach?
Mohammed Samgan Khan
Posted on • Updated on • Originally published at dev.to
what is better to remove a column or make it null in MySQL.
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (4)
If you are sure you don't need the data, do a backup and then drop the column
drop - 1
null - 0
You'll also avoid selecting the data in case of
SELECT *Agreed with rhymes. If you think you might need the data then keep/backup it otherwise remove the column. There is no point in keeping something that you won't use ever.