delete data from a column?

[Netherbeast]

Anyone know the correct command to delete data from an entire column?
I know how to delete the column, but not just the data.

Thanks in advance

 

[dsanchez2]

There is not such a thing of deleting the value of a column. You can change the value of a column to another value. This new value can be NULL (which means that the column has not value). For example:

UPDATE table1
SET column1 = NULL;

The above will set to NULL the value of column1 on the whole table. Add a WHERE clause if you want to restrict this to only certain rows.

 

[Netherbeast]

Thanks dsanchez2.