Insert variable into sqlite data base table

Question

I can't insert data into sqlite table. Here is my code:

import sqlite3
connection = sqlite3.connect('mydata.db')
cursor = connection.cursor()
a=raw_input('name')
a=str(a)
b=raw_input('theme')
b=str(b)
c=raw_input('language')
c=str(c)
sql="INSERT INTO Website (Website, Theme, Language) VALUES (%, %, %)",(a,b,c)
cursor.execute(sql)
connection.commit()
connection.close()

For some reason it doesn't work.

jfs · Accepted Answer · 2012-02-19 14:47:57Z

1

the extended call syntax is f(*args):
```
cursor.execute(*sql)
```

sqlite uses '?' placeholder:

conn.execute('insert into sometable values (?,?,?)', (a,b,c))

raw_input() already returns a string. a = str(a) is unnecessary

answered Feb 19, 2012 at 14:47

jfs

417k210 gold badges1k silver badges1.7k bronze badges

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

2 Comments

user1119429 Over a year ago

thanks I tried your code and I get the following error message: Traceback (most recent call last): File "C:\Users\Soso\Desktop\projetpython\database \insert_variables.py", line 13, in <module> cursor.execute(sql) ValueError: operation parameter must be str or unicode

jfs Over a year ago

@user1119429: update your question and add full traceback and the code that you've tried.

Collectives™ on Stack Overflow

Insert variable into sqlite data base table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related