--TEST-- PDO MySQL auto_increment / last insert id --SKIPIF-- --FILE-- query("CREATE TABLE test (id int auto_increment primary key, num int)")); print_r($db->query("INSERT INTO test (id, num) VALUES (23, 42)")); print_r($db->query("INSERT INTO test (num) VALUES (451)")); print_r($db->lastInsertId()); --EXPECT-- PDOStatement Object ( [queryString] => CREATE TABLE test (id int auto_increment primary key, num int) ) PDOStatement Object ( [queryString] => INSERT INTO test (id, num) VALUES (23, 42) ) PDOStatement Object ( [queryString] => INSERT INTO test (num) VALUES (451) ) 24