Last updated on May 26th, 2016 at 01:00 pm

MySQL command to empty column

For instance I have a table called data and a column called data_path – how do I empty the column data_path without deleting the column itself?
Just use this command

update table_name set column_name="";

column_name -> Will be your own column name to empty.

Leave a Reply

Your email address will not be published. Required fields are marked *