Website Scripts And Cloud Tutorials

MySQL command to empty column

Byadmin

Mar 5, 2014 ,

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

Click to rate this tutorial!
[Total: 1 Average: 5]

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.

Click to rate this tutorial!
[Total: 1 Average: 5]

Leave a Reply

Your email address will not be published.