insert NULL to mysql table.
| From: | anders thoresson | Date: | Wed, 02 Jul 2003 12:59:32 +0000 |
| Subject: | insert NULL to mysql table. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29018@lists.php.net to get a copy of this message | ||
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?
--
anders thoresson