OperationalError: near ",": syntax error - SQLITE3

Question

This is my code (from the "Python for Data Analysis" book):

import sqlite3

query = """ CREATE TABLE test (a VARCHAR(20), b VARCHAR(20)), c REAL, d INTEGER); """
con = sqlite3.connect('mydata.sqlite')
con.execute(query)

This is the error I get:

OperationalError                          Traceback (most recent call last)
<ipython-input-223-702795376e74> in <module>()
      1 con = sqlite3.connect('mydata.sqlite')
----> 2 con.execute(query)

OperationalError: near ",": syntax error

I tried with single and triple quotes around the code, checked the commas, but I can't figure out whats wrong.

Paul Palmpje · Accepted Answer · 2018-02-16 10:12:14Z

2

Did you check the brackets? I can see 3 opening ( and 4 closing ). Looks like you need to remove one of the two closing for b VARCHAR(20))

edited Feb 16, 2018 at 10:12

answered Feb 16, 2018 at 10:00

Paul Palmpje

2002 silver badges11 bronze badges

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

1 Comment

Gabriela Catalina Over a year ago

That was it. Thank you

Matt · Accepted Answer · 2018-02-16 10:09:01Z

1

Always count your brackets and no need for triple " here.

import sqlite3

query = " CREATE TABLE test (a VARCHAR(20), b VARCHAR(20), c REAL, d INTEGER); "
con = sqlite3.connect('mydata.sqlite')
con.execute(query)

answered Feb 16, 2018 at 10:09

Matt

15.1k28 gold badges109 silver badges161 bronze badges

Comments

MaxU - stand with Ukraine · Accepted Answer · 2018-02-16 10:15:33Z

1

Your are using Pandas - you don't need to care of "create table ..." things. Pandas does it for you:

In [100]: df = pd.DataFrame(np.random.randint(5,size=(5,3)), columns=list('abc'))

In [101]: df
Out[101]:
   a  b  c
0  1  0  0
1  0  0  3
2  0  4  1
3  0  2  0
4  0  3  1

In [102]: conn = sqlite3.connect('c:/temp/test.sqlite')

In [103]: df.to_sql('test', conn, index=False)

In [104]: df2 = pd.read_sql('select * from test', conn)

In [105]: df2
Out[105]:
   a  b  c
0  1  0  0
1  0  0  3
2  0  4  1
3  0  2  0
4  0  3  1

answered Feb 16, 2018 at 10:15

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

1 Comment

Gabriela Catalina Over a year ago

Thanks, I didn't know that. I'm gonna look into that

Ramesh Rajendran · Accepted Answer · 2018-02-16 10:24:28Z

1

Try this

query = "CREATE TABLE test (a VARCHAR(20), b VARCHAR(20), c REAL, d INTEGER)";

instead of yours

edited Feb 16, 2018 at 10:24

answered Feb 16, 2018 at 10:03

Ramesh Rajendran

38.9k49 gold badges159 silver badges241 bronze badges

Collectives™ on Stack Overflow

OperationalError: near ",": syntax error - SQLITE3

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related