1.python操作mysql
安装MYSQLdb库
库地址:http://pan.baidu.com/disk/home?fr=ibaidu#path=%252F%25E8%25BD%25AF%25E4%25BB%25B6%25E9%259B%2586%25E5%2590%2588
2.编辑mysql的配置文件
地址:C:\ProgramData
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
3.数据表建立:
DEFAULT CHARSET=gbk
4.数据库连接:
db = MySQLdb.connect(host="localhost",user="root",passwd="123456",db="monitor_tieba",port=3306,charset='gbk')
即可保证中文存入正常显示。