note 60282 deleted from function.sqlite-last-insert-rowid by cmb
| From: | cmb@php.net | Date: | Mon, 02 Nov 2020 15:00:59 +0000 |
| Subject: | note 60282 deleted from function.sqlite-last-insert-rowid by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-215742@lists.php.net to get a copy of this message | ||
Note Submitter: ffoeg at shaw dot ca
----
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.