#coding=utf-8

 import MySQLdb

 try:

     conn = MySQLdb.connect(host='localhost', port=3306, db='python3', user='root', passwd='mysql', charset='utf8')

     cursor1 = conn.cursor()

     sql = 'insert into students(name) values("郭小二")'

     cursor1.execute(sql)

     conn.commit()

     cursor1.close()

     conn.close()

 except Exception, e:

     print(e.message)

 import pymysql

 try:

     conn = pymysql.connect(host='localhost', port=3306, db='python3', user='root', passwd='mysql', charset='utf8')

     cursor1 = conn.cursor()

     sql = 'insert into students(name) values("郭小二")'

     cursor1.execute(sql)

     conn.commit()

     cursor1.close()

     conn.close()

 except Exception:

     print(e.message)