how to set a mysql row to null ? 1

[z3phir]

how do i set a mysql row to null ? example i have table forms with field formid how do i set it to null ?

 

[sleipnir214]

I'm not sure what you're asking to do.

Generally, you don't set a row no NULL -- you delete it.

You can set a particular column in a particular column to NULL using an UPDATE query:

UPDATE tablename SET columnname = NULL WHERE someothercolumnname = somevalue


Keep in mind, however, that in MySQL there is a difference between an empty value and a NULL value. Read here:

http://www.mysql.com/doc/en/Working_with_NULL.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!