python字典mysql不插入(python dictionary mysql not insert)

python字典mysql不插入(python dictionary mysql not insert)

我从以下代码中获取了一个字典'p'，但无法插入到mysql数据库中。请帮我将数据插入数据库。

字典是：[（'Casssandraw'，'烹饪'），（'Archanea'，'播放'），（'Adarshan'，'编程'），（'Leelal'，'Baking'）]应存储到名称和爱好领域。

Name Hobby Cassandraw Cooking Archanea Playing ... ...

程序：

import MySQLdb import re db = MySQLdb.connect(host="localhost", # your host, usually localhost user="root", # your username passwd="mysql", # your password db="sakila") # n with open('qwer2.txt','r') as file, db as cursor: f = open('qwer2.txt', 'r') lines = f.readlines() for x in lines: p=re.findall(r'(?:name is|me)\s+(\w+).*?(?:interest|hobby)\s+is\s+(\w+)',x, re.I) print p cursor.execute( '''INSERT INTO Details (Names, Hobby) VALUES (%s, %s)''', (name, hobby))#<-donot know what to provide db.commit()

I obtaines a dictionary 'p' from the following code,but cannot able to insert into the mysql database.please help me to insert the datas into database.

dictionary is :[('Casssandraw', 'Cooking'), ('Archanea', 'Playing'), ('Adarshan', 'Programming'), ('Leelal', 'Baking')] should be stored to Names and Hobby fields.

Name Hobby Cassandraw Cooking Archanea Playing ... ...

Program:

import MySQLdb import re db = MySQLdb.connect(host="localhost", # your host, usually localhost user="root", # your username passwd="mysql", # your password db="sakila") # n with open('qwer2.txt','r') as file, db as cursor: f = open('qwer2.txt', 'r') lines = f.readlines() for x in lines: p=re.findall(r'(?:name is|me)\s+(\w+).*?(?:interest|hobby)\s+is\s+(\w+)',x, re.I) print p cursor.execute( '''INSERT INTO Details (Names, Hobby) VALUES (%s, %s)''', (name, hobby))#<-donot know what to provide db.commit()

最满意答案

看起来你有一个包含名字/爱好而不是dict的元组列表：

您可以打开两个并插入：

for name, hobby in p: # I am presuming p is the list you posted in your question cursor.execute( '''INSERT INTO Details (Names, Hobby) VALUES (%s, %s)''', (name, hobby))#<-donot know what to provide for name,hobby in p: print name,hobby Casssandraw Cooking Archanea Playing Adarshan Programming Leelal Baking

It looks like you have a list of tuples containing name/hobby not a dict:

You can unpack the two and insert:

for name, hobby in p: # I am presuming p is the list you posted in your question cursor.execute( '''INSERT INTO Details (Names, Hobby) VALUES (%s, %s)''', (name, hobby))#<-donot know what to provide for name,hobby in p: print name,hobby Casssandraw Cooking Archanea Playing Adarshan Programming Leelal Baking