Page 1 of 1

Entering NULLs into DB

Posted: Mon Aug 11, 2008 9:25 am
by jkashu
How do I enter a NULL into a certain column in my database?

This probably isn't right, but it show what I want to do...

Code: Select all

UPDATE example SET age=NULL

Re: Entering NULLs into DB

Posted: Mon Aug 11, 2008 9:30 am
by jayshields
Have you tried that?

Re: Entering NULLs into DB

Posted: Mon Aug 11, 2008 9:31 am
by Apollo
Your query is correct. Keep in mind that this will set the age to NULL for every record in your example table.

Re: Entering NULLs into DB

Posted: Mon Aug 11, 2008 10:13 am
by jkashu
lol..I didn't actually try it. I figure that it would be more complicated than that. Thanks so much!