1
Developer's Corner / SQlite + Php 5.2.9 + Apache2.2
« on: July 19, 2009, 09:20 PM »
Can someone please help me with sqlite.
I am using SQlite + Php 5.2.9 + Apache2.2.
I can create a table using "CREATE TABLE startup (row_id INTEGER PRIMARY KEY"
But when I try to use "CREATE TABLE startup IF NOT EXISTS (row_id INTEGER PRIMARY KEY" or "CREATE TABLE IF NOT EXISTS startup (row_id INTEGER PRIMARY KEY" I am getting this error.
"Error in query: SQL logic error or missing database"
Does anyone know if the "IF NOT EXISTS" statement can be used with SQlite, Php 5.2.9 + Apache2.2. or is there an other way of checking if a table does exists before trying to create it.
I am using SQlite + Php 5.2.9 + Apache2.2.
I can create a table using "CREATE TABLE startup (row_id INTEGER PRIMARY KEY"
But when I try to use "CREATE TABLE startup IF NOT EXISTS (row_id INTEGER PRIMARY KEY" or "CREATE TABLE IF NOT EXISTS startup (row_id INTEGER PRIMARY KEY" I am getting this error.
"Error in query: SQL logic error or missing database"
Does anyone know if the "IF NOT EXISTS" statement can be used with SQlite, Php 5.2.9 + Apache2.2. or is there an other way of checking if a table does exists before trying to create it.