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?
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?
For further actions, you may consider blocking this person and/or reporting abuse
Scofield Idehen -
Dhimas Kirana -
Judy -
Peter Kim Frank -
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.