Syntax error in sqlite statement in python?

Question

I have the following code fragment in an object initializer. However, the third line below gives the error sqlite3.OperationalError: near "(": syntax error

self._conn = sqlite3.connect('dictionary')
cursor = self._conn.cursor()
cursor.execute('CREATE TABLE `words` (`word` VARCHAR(15) NOT NULL, PRIMARY (`word`));')

Any ideas as to what could be causing this. I'm far from an export at SQL but I fail to see what I did incorrectly.

Jacob · Accepted Answer · 2011-08-18 06:48:29Z

4

You are missing a KEY here.

CREATE TABLE `words` (`word` VARCHAR(15) NOT NULL, PRIMARY KEY(`word`))

answered Aug 18, 2011 at 6:48

Jacob

43.6k6 gold badges81 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

hamstergene · Accepted Answer · 2011-08-18 06:49:08Z

0

PRIMARY word is not valid SQL. Use

CREATE TABLE words (word VARCHAR(15) NOT NULL PRIMARY KEY);

answered Aug 18, 2011 at 6:49

hamstergene

24.5k5 gold badges60 silver badges73 bronze badges

Collectives™ on Stack Overflow

Syntax error in sqlite statement in python?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related