jeudi 17 décembre 2015

Unknown sql(ite) query syntax error

Why is the following invalid, i'm at a loss here?

'CREATE TABLE IF NOT EXISTS Mons(id int PRIMARY KEY NOT NULL AUTO_INCREMENT, keyword VARCHAR(255) NOT NULL);'

From node.js's sqlite3, in coffeescript as:

db.parallelize( () ->
    db.run('CREATE TABLE IF NOT EXISTS Mons(id int PRIMARY KEY NOT NULL AUTO_INCREMENT, keyword VARCHAR(255) NOT NULL);')
    )

Exact error:

Error: SQLITE_ERROR: near "AUTO_INCREMENT": syntax error
  at Error (native)

Aucun commentaire:

Enregistrer un commentaire