sqlite2 autoincrement error

Asked Dec 24 '13 at 21:54

Active Dec 24 '13 at 22:27

Viewed 293 times

I have a problem with sqlite2 (not sqlite3, because I use php).

I tried to create a table with the following query:

CREATE TABLE Messaggi (id INTEGER PRIMARY KEY AUTOINCREMENT,content TEXT, date DATETIME DEFAULT (date('now')), owner TEXT, viewed INTEGER DEFAULT (1))

But when I launched the script, this output was produced:

near "AUTOINCREMENT": syntax error

Where's the error?

Ok, I handle it. But now, i get this error:

near "(": syntax error

, with the query:

CREATE TABLE Messaggi (id INTEGER PRIMARY KEY DEFAULT('(SELECT COUNT(*) FROM 
Messaggi)+1'),content TEXT, date DATETIME DEFAULT (strftime('%s','now')), owner TEXT, 
viewed INTEGER DEFAULT (1))

edited Dec 24 '13 at 22:27

asked Dec 24 '13 at 21:54

donadev

2

If I'm reading the sqlite release notes correctly, the `autoincrement` keyword was added in 3.1.0. http://www.sqlite.org/changes.html – Barmar Dec 24 '13 at 21:57
ok thanks! at least I found the error... – donadev Dec 24 '13 at 21:59
I doubt you can put a string of SQL as the `DEFAULT` value. – Barmar Dec 24 '13 at 22:19
but in sqlite3 it works fine... – donadev Dec 24 '13 at 22:20

sqlite2 autoincrement error

0 Answers0