Python向MySQL中插入中文数据:
1.中文数据在Python中给出
代码:
#encoding=utf-8
import MySQLdb
import time
conn=MySQLdb.connect(user="root",passwd="admin",db="data",charset="utf8")
cursor = conn.cursor()
sql = "drop table if exists users"
cursor.execute(sql)
sql = "create table if not exists users (name varchar(60), addr varchar(60),time datetime);"
cursor.execute(sql)
name = u'李明'
print name
addr =[u'北京',u'天津',u'上海']
print addr
for s in addr:
sql = "insert into users values ('%s','%s',now())"%(name,s)
print sql
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()
结果:
2.中文数据由网页中或者文件中获得
代码: