With NULL you can check it usign the IS NULL operator. NULL could be a different use from the programer, like a row that IS NULL is a ROW that never have a data in that column, but a row with no data could be a row that was changed to that value.
You could define the default value when is constructing the table definition to null and use it in this way, or other combinations. []s Slepetys ----- Original Message ----- From: "Radek Zajkowski [m3f.org]" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 06, 2004 10:49 PM Subject: NULL versus just empty > What is the difference between allowing NULL value in a field vs not > specifying allow NULL. > > R> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]