note 60282 added to function.sqlite-last-insert-rowid

From: Date: Mon, 02 Jan 2006 01:53:45 +0000
Subject: note 60282 added to function.sqlite-last-insert-rowid
Groups: php.notes 
Request: Send a blank email to php-notes+get-101093@lists.php.net to get a copy of this message
Note that if you insret a few rows in your table, say rowid 1-5, and then delete 2,3 and 4, you will be left with the rowids 1 and 5, not 1 and 2. This may seem basic to anyone with database experience, but I had to check it out with a GUI tool before I figured this one out. Anyway, what it boils down to is that sometimes your rowid will be greater than the number returned by the SQLite COUNT (*) function. ---- Manual Page -- http://www.php.net/manual/en/function.sqlite-last-insert-rowid.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+60282 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+60282&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+60282&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+60282&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+60282&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+60282&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+60282&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+60282&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+60282&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#101093) next »