Posted on • Updated on • Originally published at dev.to
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
akshay-lite -
Sloan the DEV Moderator -
Emilio and Kaylee -
Bogomil Shopov - ΠΠΎΠ³ΠΎ -
Once suspended, msamgan will not be able to comment or publish posts until their suspension is removed.
Once unsuspended, msamgan will be able to comment and publish posts again.
Once unpublished, all posts by msamgan will become hidden and only accessible to themselves.
If msamgan is not suspended, they can still re-publish their posts from their dashboard.
Once unpublished, this post will become invisible to the public and only accessible to Mohammed Samgan Khan.
They can still re-publish the post if they are not suspended.
Thanks for keeping DEV Community safe. Here is what you can do to flag msamgan:
Unflagging msamgan will restore default visibility to their posts.
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.