[MySQL] Nulling something

[becool007]

Okay so I use MySQL. Now i wanted to know that when I entered a value into a table that was NULLED it shows the value like everything else. But, when I want to reverse this. I cannot seem to NULL it again. Im 100% sure there is a script to do this. But i wanna do it with the QueryBrowser/Editor function.

Thank you
~becool

 

[alexz003]

i can't necisarily give you code for this since i don't know MySql much but i can tell you this much. Originally when you are putting in data using the code in the query box at the top you first have to say what item you are editing(specifically) and give it the value of NULL through the query.

 

[FragFrog]

If you mean the MySQL Query Browser tool:

1. Doubleclick the table concerned, ctrl-enter to get the contents
2. Hit the 'Edit' button at the bottom.
3. Go to the field you wish to NULL, rightclick it, 'clear field content'.

Alternatively you can use a script like this:

UPDATE  `table`
SET     `column` = NULL
WHERE   `condition`