note 82596 deleted from function.sqlite-exec by cmb
| From: | cmb@php.net | Date: | Mon, 02 Nov 2020 14:59:11 +0000 |
| Subject: | note 82596 deleted from function.sqlite-exec by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-215729@lists.php.net to get a copy of this message | ||
Note Submitter: nonproffessional at clockworkgeek dot com
----
Just to point out that "CREATE TABLE IF NOT EXISTS" is only supported in SQLite version
3.3.0 or above. And PHP (currently 5.2.5) only comes with SQLite version 2.1.
Executing a create table like this will throw an error as will creating a table that already exists.
Instead execute a normal "CREATE TABLE" command and catch it with "try {..}
catch".