Insert data from a Python dictionary to MySQL

Question

I want to insert dictionary data into mysql each key in its own field. I tried following code. But its wrong. Can any one help? I really appreciate. thanks so much :-)

d = {"spam": "1", etc,etc,"egg": "2"}
cols = d.keys()
vals = d.values()

stmt = "INSERT INTO table (%s) VALUES(%s)" % (
",".join(cols), ",".join(len(vals))

sharvey · Accepted Answer · 2011-10-27 17:00:04Z

2

Why do you call len(vals) ? Your code should work by simply removing that.

answered Oct 27, 2011 at 17:00

sharvey

8,2257 gold badges51 silver badges67 bronze badges

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

2 Comments

no_freedom Over a year ago

thanks I want to insert single quote around values. How can I add ?

sharvey Over a year ago

Probably not the prefered way, but you can do: VALUES(\"%s\") ... % '", "'.join(vals);

Collectives™ on Stack Overflow

Insert data from a Python dictionary to MySQL

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