Re: insert NULL to mysql table.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> '$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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux