My apologies.. I scanned back looking for the reference but couldn't find it... I thought it worth reiterating what turned out to be your point because there seems to be so much confusion around this issue.
- michael On 8/9/07, Brent Baisley <[EMAIL PROTECTED]> wrote: > Actually, I said to make sure you are NOT quoting it. The advice > wasn't to add quotes. > > On Aug 9, 2007, at 2:27 PM, Michael Dykman wrote: > > > IF it is a null in that column, you should not see the word 'null'.. > > and the advise to put quotes around it I read earlier in this thread > > is completely misguided.. If you insert the string 'null' or 'NULL' > > into the database, you have just strored a string.. > > > > Perhaps it is the form of your queries: NULL needs special handling. > > YOu cant say > > SELECT * FROM foo WHERE bar = null; > > > > you need to specify: > > SELECT * FROM foo WHERE bar IS NULL; > > > > Nothing ever 'equals' NULL in SQL not even another NULL.. > > > > - michael > > > > > > On 8/9/07, Mahmoud Badreddine <[EMAIL PROTECTED]> wrote: > >> I did remove that column from the insert statement and no text > >> appeared at > >> all in that field under that column. Not even the word "NULL". > >> > >> On 8/8/07, Christian High <[EMAIL PROTECTED]> wrote: > >>> > >>> On 8/8/07, Brent Baisley <[EMAIL PROTECTED]> wrote: > >>>> One thing to check is to make sure you are not quoting your NULL > >>>> value for your insert statement. MySQL will try to convert that > >>>> to a > >>>> numeric value, which may end up as 0. > >>>> > >>>> On Aug 8, 2007, at 12:55 PM, Mahmoud Badreddine wrote: > >>>> > >>>>> Hello > >>>>> I have a table which contain a few numerical values. > >>>>> I set the default values to be NULL. > >>>>> When I insert values using phpMyAdmin, it sets the values to NULL > >>>>> correctly. > >>>>> But when I insert using a PHP script that I wrote it sets the > >>>>> values > >>>>> to 0.00or 0. > >>>>> In my script I do test if the values are empty and in case they > >>>>> are > >>>>> I set > >>>>> the variable to NULL. But that still doesn't help. > >>>>> Is that a mysql problem ? > >>>>> Thank you. > >>>>> > >>>>> -- > >>>>> -Mahmoud Badreddine > >>>>> > >>>>> http://www.spreadfirefox.com/ > >>>> > >>>> > >>>> -- > >>>> MySQL General Mailing List > >>>> For list archives: http://lists.mysql.com/mysql > >>>> To unsubscribe: http://lists.mysql.com/mysql? > >>>> [EMAIL PROTECTED] > >>>> > >>>> > >>> As long as you are testing to see if they should be null, and the > >>> default is set to null, you could exclude the column all together > >>> from > >>> the insert statement and you should see they are then recorded in > >>> the > >>> table as null. > >>> > >>> cj > >>> > >> > >> > >> > >> -- > >> -Mahmoud Badreddine > >> > >> http://www.spreadfirefox.com/ > >> > > > > > > -- > > - michael dykman > > - [EMAIL PROTECTED] > > > > - All models are wrong. Some models are useful. > > -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
