MYSQL: Empty single column of a table

A single column in a MySQL table can be emptied with the following command:

UPDATE table_name SET column = NULL
MySQL - Delete single database column

MySQL is a relational database management system (RDBMS) that provides multi-user access to several databases. It is a prevalent database management system and comes at no cost.

http://dev.mysql.com/doc/refman/5.0/en/update.html

You may also like...

Leave a Reply

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