python + sqlite, insert data from variables into table

Question

I can insert hardcoded values into an SQLite table with no problem, but I'm trying to do something like this:

name = input("Name: ")
phone = input("Phone number: ")
email = input("Email: ")

cur.execute("create table contacts (name, phone, email)")
cur.execute("insert into contacts (name, phone, email) values"), (name, phone, email)

I know this is wrong, and I can't find how to make it work. Maybe someone could point me in the right direction.

There are tons of obvious syntax errors in your code (you can even see it from the incorrect syntax highlighting). What error do you get? Is this the actual code you are running? If not, can you please post the actual code you tried? — Mark Byers
– Mark Byers, Commented Dec 5, 2010 at 19:12
this is not what I'm running, I just quickly typed it up for this post, just so people would get an idea what I'm trying to accomplish — steini
– steini, Commented Dec 5, 2010 at 19:25
Please accept Mark's answer, or post another solution yourself and accept that. Using [solved] in the title is not usual here. Thanks! — Arjan
– Arjan, Commented Dec 5, 2010 at 19:35

Mark Byers · Accepted Answer · 2010-12-05 19:11:07Z

64

You can use ? to represent a parameter in an SQL query:

cur.execute("insert into contacts (name, phone, email) values (?, ?, ?)",
            (name, phone, email))

answered Dec 5, 2010 at 19:11

Mark Byers

843k202 gold badges1.6k silver badges1.5k bronze badges

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

3 Comments

steini Over a year ago

Thank you sir,I had been trying some variations of that but this works :D

Amey P Naik Over a year ago

can i use a list [name, phone, email] instead of a set (name, phone, email) ?

ArduinoBen Over a year ago

@AmeyPNaik I think it needs a tuple

pro1991 · Accepted Answer · 2018-10-19 08:20:16Z

1

cur.executemany("insert into contacts (name, phone, email) values (?, ?, ?)", (name, phone, email))

answered Oct 19, 2018 at 8:20

pro1991

431 silver badge8 bronze badges

1 Comment

Anh Pham Over a year ago

Usually it's better to explain a solution instead of just posting some rows of anonymous code. You can read How do I write a good answer, and also Explaining entirely code-based answers

Suraj Rao · Accepted Answer · 2020-08-12 10:13:05Z

1

cur.execute("create table contacts (name, phone, email)")

cur.execute("insert into contacts (name, phone, email) values(?,?,?)",(name, phone, email))

OR

cur.execute("insert into contacts values(?,?,?)",(name, phone, email))

As you are inserting values to all available fields, its okay not to mention columns name in insert query

edited Aug 12, 2020 at 10:13

Suraj Rao

29.7k11 gold badges96 silver badges104 bronze badges

answered Aug 12, 2020 at 10:09

Sameer Ranjan Sahoo

111 bronze badge

Collectives™ on Stack Overflow

python + sqlite, insert data from variables into table

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related