Python insert to mysql

Question

I am trying to insert some values from python to MySQL and I receive the following error.

Connection and code in Python:

conn = MySQLdb.connect(host="localhost",user="lpr",passwd="B1ack53@",db="lpr")
c=conn.cursor()
c.execute("INSERT INTO liccaptured(realtime, proctime, plate, confid, uuid) VALUES (%s,%s,%s,%s,%s)", realtime,proctime,plate,confid,uuid)

Error message:

c.execute("INSERT INTO liccaptured(realtime, proctime, plate, confid, uuid) VALUES (%s,%s,%s,%s,%s)", realtime,proctime,plate,confid,uuid)
TypeError: execute() takes at most 3 arguments (7 given)

I tried looking for similar errors and could not figure out what I am doing wrong. Any help is appreciated thanks.

chucksmash · Accepted Answer · 2015-09-07 01:13:53Z

1

The error you are running into comes from the fact that you are treating the cursor.execute method as one which accepts a variable number of arguments:

c.execute(operation, arg1, arg2, ..., argn)  # won't work

execute only accepts a fixed number of arguments though. The paramaters to the SQL statement itself are passed in as a single argument that is a tuple:

my_args = (arg1, arg2, ..., argn)
c.execute(operation, my_args)                  # this will work
c.execute(operation, (arg1, arg2, ..., argn))  # just the same as above

answered Sep 7, 2015 at 1:13

chucksmash

6,0671 gold badge36 silver badges41 bronze badges

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

Comments

David Ferenczy Rogožan · Accepted Answer · 2015-09-07 01:15:20Z

0

Error message says everything: the function execute has at most 3 arguments, but you're calling it with 7 arguments. So you just need to call it properly with 3 arguments.

According to documentation, execute function's syntax is as follows:

cursor.execute(operation, params=None, multi=False)

operation is SQL query as string
params is an array of parameters
multi is boolean flag

answered Sep 7, 2015 at 1:15

David Ferenczy Rogožan

25.7k12 gold badges88 silver badges73 bronze badges

Comments

Parfait · Accepted Answer · 2015-09-07 02:42:58Z

0

You did not correctly pass the tuple string operator. Consequently, c.execute() assumes multiple arguments. Simply, place % just after string with no commas, and wrap all variables in parentheses

c.execute("INSERT INTO liccaptured (realtime, proctime, plate, confid, uuid) \
           VALUES (%s,%s,%s,%s,%s)" % (realtime,proctime,plate,confid,uuid))

Alternatively, consider using string format:

c.execute("INSERT INTO liccaptured (realtime, proctime, plate, confid, uuid) \
           VALUES ({0},{1},{2},{3},{4})".format(realtime,proctime,plate,confid,uuid))

answered Sep 7, 2015 at 2:42

Parfait

108k19 gold badges102 silver badges138 bronze badges

Collectives™ on Stack Overflow

Python insert to mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related