python字典mysql不插入

Question

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

字典是:[('Casssandraw', ' cooking '), ('Archanea', '玩耍'), ('Adarshan', '编程'), ('Leelal', '烘焙')]应存储到“名称”和“爱好”字段。

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()  

Answer 1

看起来您有一个包含名称/爱好而不是字典的元组列表:

您可以解压这两个并插入:

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