python连mysql 数据库问题『 mysql 'latin-1' codec can't encode ch』

最新推荐文章于 2011-11-04 14:36:28 发布

hqmanwangkai

最新推荐文章于 2011-11-04 14:36:28 发布

阅读量131

点赞数

分类专栏： python 文章标签： MySQL Python QQ

本文链接：https://blog.csdn.net/hqmanwangkai/article/details/83723468

版权

python 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

class MysqlPipeline(object):
    def process_item(self, item, spider):
        conn = MySQLdb.connect(host='localhost', user='root',passwd='')  
        conn.set_character_set("utf8")
        conn.select_db('crawl_db');  
        cursor = conn.cursor()   
        cursor.execute('set names utf8')
        print "insert into etuni values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % (item['url'],item['username'], item['email'], item['qq'],item['phone'],item['address'],item['sex'], item['birth'], item['postcount'],item['registerDate']) 
        cursor.execute("insert into etuni values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')" % (item['url'],item['username'], item['email'], item['qq'],item['phone'],item['address'],item['sex'], item['birth'], item['postcount'],item['registerDate']))   
        cursor.close(); 
        return item