Duplicate column name error sqlite3 Python

Question

I wanted to create a row with certain attributes:

querycurs.execute("CREATE TABLE CME_Equities(Contract Size TEXT, Contract Months TEXT")

However, I get an error with the names since they both start with "Contract", is there a way to force it to accept?

Martijn Pieters · Accepted Answer · 2013-05-30 20:27:57Z

1

When your column names contain whitespace you need to put quotes around the names; you are also missing a closing parenthesis:

CREATE TABLE CME_Equities('Contract Size' TEXT, 'Contract Months' TEXT)

Quick demo with the sqlite3 command line utility:

$ sqlite3 :memory:
SQLite version 3.7.16.1 2013-03-29 13:44:34
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> CREATE TABLE CME_Equities('Contract Size' TEXT, 'Contract Months' TEXT);
sqlite> .schema
CREATE TABLE CME_Equities('Contract Size' TEXT, 'Contract Months' TEXT);

or the python version:

querycurs.execute("CREATE TABLE CME_Equities('Contract Size' TEXT, 'Contract Months' TEXT)")

answered May 30, 2013 at 20:27

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

3 Comments

James Hallen Over a year ago

I was following a tutorial online and they inserted into tables like this: cur.execute("INSERT INTO Friends(Name) VALUES ('Tom');"), however, when I try a similar approach: querycurs.execute("INSERT INTO CME_Equities(elem) VALUES (cell_in_table);"), I get an error: OperationalError: no such column: cell_in_table. I thought the column is next to the name of table and values right after VALUES

Martijn Pieters Over a year ago

You'll need to follow some more SQL tutorials; when inserting a value, you can not only insert literal values, but also data from other SQL expressions. cell_in_table is seen as an expression, not a value, because you didn't use quotes.

Martijn Pieters Over a year ago

The Python equivalent would be to use foobar = somevalue instead of foobar = 'somevalue'; in the first example somevalue would be interpreted as the name of another object, but 'somevalue' is a string literal.

Collectives™ on Stack Overflow

Duplicate column name error sqlite3 Python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related