<blockquote>
<p><strong>Possible Duplicate:</strong><br/>
<a href="https://stackoverflow.com/questions/9061565/convert-list-to-string-to-insert-into-my-sql-in-one-row-in-python-scrapy">convert list to string to insert into my sql in one row in python scrapy</a> </p>
</blockquote>
<p>我编写了一个脚本将数据插入mysql,如下所示,但是它将<code>items</code>列表中的一项344次插入到mysql数据库中。我做错什么了?在</p>
<pre><code>def parse(self, response):
hxs = HtmlXPathSelector(response)
sites = hxs.select('//ul/li')
con = MySQLdb.connect(
host="localhost",
user="dreamriks",
passwd="dreamriks",
db="scraped_data"
)
cur = con.cursor()
items = []
for site in sites:
items = [site.select('//h2').extract()]
item = [site.select('//h3').extract()]
meta = [site.select('//meta').extract()]
for index in range (len( items)):
str = items[index]
cur.execute("""Insert into h2_meta(h2) Values(%s)""",(str))
</code></pre>