Re: insert NULL to mysql table.

Pete Morganic <pete@daffodil.uk.com> · Wed, 02 Jul 2003 14:21:01 +0100

> '$issue'" where $editor = " is null"
Anders Thoresson wrote:
Hi,

I've the query "UPDATE un_issue SET i_editor = '$editor' WHERE i_date = 
'$issue'" where $editor = "/0" but the inserted value in 
un_issue.i_editor becomes 0.

un_issue is defined as follows:

CREATE TABLE un_issue
(
    i_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
    i_date DATE NOT NULL,
    UNIQUE (i_date),
    i_number INT,
    i_editor INT
);

Isn't /0 the escapestring for NULL?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php