I will guess that the NULL field you defined is of a numeric
type such as INT. In standard SQL the empty string '' is not
the same as the special value NULL, and this is also true in
MySQL, but not in Oracle. Probably you are inserting a ''
into the database column but MySQL correctly interprets
At 13:59 -0500 5/10/02, Steve Buehler wrote:
>At 01:22 PM 5/10/2002, Paul DuBois wrote:
>>At 13:11 -0500 5/10/02, Steve Buehler wrote:
>>>I have found that I can NOT do this:
>>>$null = "NULL" or even $null = NULL than put that into a statement
>>>like this:
>>>UPDATE games SET game_id = '$null';
At 01:22 PM 5/10/2002, Paul DuBois wrote:
>At 13:11 -0500 5/10/02, Steve Buehler wrote:
>>I have found that I can NOT do this:
>>$null = "NULL" or even $null = NULL than put that into a statement like this:
>>UPDATE games SET game_id = '$null';
>>can't do it like this either
>>UPDATE games SET gam
At 13:11 -0500 5/10/02, Steve Buehler wrote:
>I have found that I can NOT do this:
>$null = "NULL" or even $null = NULL than put that into a statement like this:
>UPDATE games SET game_id = '$null';
>can't do it like this either
>UPDATE games SET game_id = $null;
>I have to do it like this:
>UPDAT
I have found that I can NOT do this:
$null = "NULL" or even $null = NULL than put that into a statement like this:
UPDATE games SET game_id = '$null';
can't do it like this either
UPDATE games SET game_id = $null;
I have to do it like this:
UPDATE games SET game_id = NULL;
NO QUOTES of any kind.
I created a table with a field define as NULL, however when I insert
values NULL , Mysql puts 0 instead of nothing ,
I don't understand why I have this trouble ,
Thanks
-
Before posting, please check:
http://www.mysql.c
raphael k wrote :
>
> I created a table with a field define as NULL, however when I insert
> values NULL , Mysql puts 0 instead of nothing ,
>
> I don't understand why I have this trouble ,
>
>
>
> Thanks
>
Hi,
If you don't show us your query, it will be hard to help you ...
Regards
--
Jo
I created a table with a field define as NULL, however when I insert
values NULL , Mysql puts 0 instead of nothing ,
I don't understand why I have this trouble ,
Thanks
-
Before posting, please check:
http://www.mysql
