python3访问MySQL数据库

import pymysql
db = pymysql.connect(
    host='XXXXXXXX.com',     #数据库服务器地址

    user='XXX',              #用户名
    passwd='XXX',      
    db='db_test',           #数据库名（一个数据库服务器地址中可以包含多个数据库）
    port=3306,
    charset='utf8'
)

cursor=db.cursor()
str="INSERT INTO `the_XXXX` (`XXX`, `XXX`) VALUES (333323, NULL)"
try:
    cursor.execute(str)
    db.commit()
except:
     db.rollback()
     print("失败")

db.close()

cursor=db.cursor()
str="create table test(testname char(10),testnum int) "
try:
    cursor.execute(str)
    db.commit()
except:
     db.rollback()
     print("失败")

db.close()

cursor=db.cursor()
str="select * from XXXX"
try:
    cursor.execute(str)
    db.commit()
    results=cursor.fetchall()
    for row in results:
        print(row)
except:
     db.rollback()
     print("失败")

db.close()