note 119490 added to pdo.lastinsertid

beware when mixing auto-incremented and explicit IDs! Given a fresh table "tbl", executing insert into tbl values (0, 'kaeptn blaubaer'); --auto increment (-> 1) insert into tbl values (16, 'pipi langstrumpf'); --explicit id (-> 16) select LAST_INSERT_ID(); will return 1, which is not the value of the last insert. its the value from the last auto-increment insert! (using mysql) ---- Server IP: 72.52.91.14 Probable Submitter: 217.17.27.101 ---- Manual Page -- http://php.net/manual/en/pdo.lastinsertid.php Edit -- https://master.php.net/note/edit/119490 Del: integrated -- https://master.php.net/note/delete/119490/integrated Del: useless -- https://master.php.net/note/delete/119490/useless Del: bad code -- https://master.php.net/note/delete/119490/bad+code Del: spam -- https://master.php.net/note/delete/119490/spam Del: non-english -- https://master.php.net/note/delete/119490/non-english Del: in docs -- https://master.php.net/note/delete/119490/in+docs Del: other reasons-- https://master.php.net/note/delete/119490 Reject -- https://master.php.net/note/reject/119490 Search -- https://master.php.net/manage/user-notes.php