在写爬虫的时候,想把数据存到数据库,因为python特殊的sql语法问题,再加上中文字符入库乱码,折腾了许久,最终总算OK了,贴上pymsql练习的代码,以供参考
# -*- coding: utf8 -*- ##这里要设置编码格式 import pymysql try: conn=pymysql.Connect(host='127.0.0.1',port=3306,user='root',passwd='',db='test') cur = conn.cursor() ####保存操作################################## name='张三' company = 'yyyyyyyyy' sally='12000' place='bj' publishDate='2016-12-08' others='=====' print(company) #sql="INSERT INTO user(id,name) values(5,'张三')"; ###因为部分参数为中文,需要保证数据库编码格式最好也是utf8 sql = ('INSERT INTO job(name,company,sally,place,publishDate,others) VALUES ("%s","%s","%s","%s","%s","%s")' % (name,company,sally,place,publishDate,others)) cur.execute(sql) #conn.commit(); #因为mysql是默认自动提交的,所以这里就不用再commit了 ##############查询######################## cur.execute('select * from user') data=cur.fetchall() for d in data : print(d) cur.close() conn.close() except Exception as e:print("连接异常",e)