Quick MySQL Tip

This is a tip for me as much as anyone since I have a mental block about it for some reason...

Update Column values to null

If i want to remove all the data in a mysql column. I can do it by setting the values to null like so...

UPDATE tablename Set `column_name` = Null

Powered by Drupal, an open source content management system