Deleting one item from one row?
Moderator: General Moderators
Deleting one item from one row?
I am wondering if someone could please tell me how I can delete one item from one row with mysql? Thanks in advance.
Code: Select all
UPDATE table_name SET item_to_delete = NULL WHERE ...
If NULL doesn't work, it means the column is set up to not accept NULL, in which case the best you can do is to change it to '' (blank string), or 0 (in case of integer)