Not enough arguments for format string Python-MySQL

Question

I'm getting this error in python and i don't know how to solve it. Sorry for my english, is not my native language :(

TypeError: not enough arguments for format string

save_data = "INSERT INTO mediciones_historial VALUES('%s', '%s', '%s', '%s')" % (sensor, data, data_type)

In my database I have five rows:

id (int) sensor (int) data (text) data_type(text) fecha(timestamp)

What is that I'm doing wrong?

Thanks!

coder3521 · Accepted Answer · 2015-07-25 22:51:18Z

3

In your code:

save_data = "INSERT INTO mediciones_historial VALUES('%s', '%s', '%s', '%s')" % (sensor, data, data_type)

The number of %s specifier doesn't matches number of arguments you are passing, also the column names are missing after table name

you have to make it according to the column in table but python always have a better choice.

Try using this :

save_data = "INSERT INTO mediciones_historial(column1,column2,column3) VALUES({0},{1},{2})".format(sensor, data, data_type)

but you have to take care of data type i.e if it is string or date type then use single quotes(') : '{0}' instead of {0}.

Also the above seems more understandable and readable. :)

answered Jul 25, 2015 at 22:51

coder3521

2,6461 gold badge30 silver badges51 bronze badges

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

3 Comments

coder3521 Over a year ago

I am glad that it helped . You may like to accept my answer also :)

user9170 Over a year ago

This is terrible. This is vulnerable to SQL injection. execute("INSERT INTO mediciones_historial(column1,column2,column3) VALUES(%s, %s, %s)", [sensor,data,data_type])

Nick Duddy Over a year ago

@csharpcoder First variation of the example worked perfectly for me. I struggled to implement the second one.

Samir Selia · Accepted Answer · 2015-07-25 23:11:41Z

3

This is because the number of values does not match the number of arguments.

save_data = "INSERT INTO mediciones_historial VALUES('%s', '%s', '%s', '%s')" % (sensor, data, data_type, fecha)

edited Jul 25, 2015 at 23:11

answered Jul 25, 2015 at 22:27

Samir Selia

7,1502 gold badges14 silver badges33 bronze badges

2 Comments

EEBB Over a year ago

Thanks for the reply. Now I have this error: "Column count doesn't match value count at row 1".

Samir Selia Over a year ago

Got it. Your table schema has 5 columns and we missed fecha column in insert query. Have updated my post above.

Collectives™ on Stack Overflow

Not enough arguments for format string Python-MySQL

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related