ID: 29546
Comment by: hugo at concepto dot com dot br
Reported By: webmaster at realscripts dot de
Status: Open
Bug Type: SQLite related
Operating System: Linux
PHP Version: 4.3.8
New Comment:
I think this is not a bug.
try:
sqlite_query("INSERT INTO test_tbl VALUES (NULL, 'mark')");
or
sqlite_query("INSERT INTO test_tbl (name) VALUES ('mark')");
or if it is a bug, is a SQLite bug, not a PHP bug.
Previous Comments:
------------------------------------------------------------------------
[2004-08-06 13:39:38] webmaster at realscripts dot de
Description:
------------
When I have an auto_increment Integer Field in my SQLite DB and I
insert data the auto_increment-field gets NULL as value.
Reproduce code:
---------------
CREATE TABLE test_tbl (
ID INTEGER PRIMARY KEY,
name VARCHAR
);
sqlite_open('test.db');
sqlite_query("INSERT INTO test_tbl VALUES ('mark')");
Expected result:
----------------
ID | name
---------
1 | mark
Actual result:
--------------
ID | name
-----------
NULL | mark
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=29546&edit=1
