$ git clone https://github.com/PyMySQL/PyMySQL
$ cd PyMySQL
$ python3 setup.py install

$ # X.X 為PyMySQL 的版本號
$ curl -L https://github.com/PyMySQL/PyMySQL/tarball/pymysql-X.X | tar xz
$ cd PyMySQL*
$ python3 setup.py install

#!/usr/bin/python3
__author__ = 'mayi'

import pymysql

# 打開數(shù)據(jù)庫連接
db = pymysql.connect("localhost","testuser","test123","TESTDB" )

# 使用 cursor() 方法創(chuàng)建一個游標對象 cursor
cursor = db.cursor()

# 使用 execute() 方法執(zhí)行 SQL 查詢 
cursor.execute("SELECT VERSION()")

# 使用 fetchone() 方法獲取單條數(shù)據(jù).
data = cursor.fetchone()

print ("Database version : %s " % data)

# 關閉數(shù)據(jù)庫連接
db.close()

#!/usr/bin/python3
__author__ = 'mayi'

import pymysql

# 打開數(shù)據(jù)庫連接
db = pymysql.connect("localhost","testuser","test123","TESTDB" )

# 使用 cursor() 方法創(chuàng)建一個游標對象 cursor
cursor = db.cursor()

# 使用 execute() 方法執(zhí)行 SQL，如果表存在則刪除
cursor.execute("DROP TABLE IF EXISTS EMPLOYEE")

# 使用預處理語句創(chuàng)建表
sql = """CREATE TABLE EMPLOYEE (
 FIRST_NAME CHAR(20) NOT NULL,
 LAST_NAME CHAR(20),
 AGE INT, 
 SEX CHAR(1),
 INCOME FLOAT )"""

cursor.execute(sql)

# 關閉數(shù)據(jù)庫連接
db.close()

#!/usr/bin/python3
__author__ = 'mayi'

import pymysql

# 打開數(shù)據(jù)庫連接
db = pymysql.connect("localhost","testuser","test123","TESTDB" )

# 使用cursor()方法獲取操作游標 
cursor = db.cursor()

# SQL 插入語句
sql = """INSERT INTO EMPLOYEE(FIRST_NAME,
 LAST_NAME, AGE, SEX, INCOME)
 VALUES ('Mac', 'Mohan', 20, 'M', 2000)"""
try:
 # 執(zhí)行sql語句
 cursor.execute(sql)
 # 提交到數(shù)據(jù)庫執(zhí)行
 db.commit()
except:
 # 如果發(fā)生錯誤則回滾
 db.rollback()

# 關閉數(shù)據(jù)庫連接
db.close()

#!/usr/bin/python3
__author__ = 'mayi'

import pymysql

# 打開數(shù)據(jù)庫連接
db = pymysql.connect("localhost","testuser","test123","TESTDB" )

# 使用cursor()方法獲取操作游標 
cursor = db.cursor()

# SQL 插入語句
sql = "INSERT INTO EMPLOYEE(FIRST_NAME, \
 LAST_NAME, AGE, SEX, INCOME) \
 VALUES ('%s', '%s', '%d', '%c', '%d' )" % \
 ('Mac', 'Mohan', 20, 'M', 2000)
try:
 # 執(zhí)行sql語句
 cursor.execute(sql)
 # 執(zhí)行sql語句
 db.commit()
except:
 # 發(fā)生錯誤時回滾
 db.rollback()

# 關閉數(shù)據(jù)庫連接
db.close()

#!/usr/bin/python3
__author__ = 'mayi'

import pymysql

# 打開數(shù)據(jù)庫連接
db = pymysql.connect("localhost","testuser","test123","TESTDB" )

# 使用cursor()方法獲取操作游標 
cursor = db.cursor()

# SQL 查詢語句
sql = "SELECT * FROM EMPLOYEE \
 WHERE INCOME > '%d'" % (1000)
try:
 # 執(zhí)行SQL語句
 cursor.execute(sql)
 # 獲取所有記錄列表
 results = cursor.fetchall()
 for row in results:
 fname = row[0]
 lname = row[1]
 age = row[2]
 sex = row[3]
 income = row[4]
 # 打印結果
 print ("fname=%s,lname=%s,age=%d,sex=%s,income=%d" % \
 (fname, lname, age, sex, income ))
except:
 print ("Error: unable to fecth data")

# 關閉數(shù)據(jù)庫連接
db.close()

#!/usr/bin/python3
__author__ = 'mayi'

import pymysql

# 打開數(shù)據(jù)庫連接
db = pymysql.connect("localhost","testuser","test123","TESTDB" )

# 使用cursor()方法獲取操作游標 
cursor = db.cursor()

# SQL 更新語句
sql = "UPDATE EMPLOYEE SET AGE = AGE + 1
 WHERE SEX = '%c'" % ('M')
try:
 # 執(zhí)行SQL語句
 cursor.execute(sql)
 # 提交到數(shù)據(jù)庫執(zhí)行
 db.commit()
except:
 # 發(fā)生錯誤時回滾
 db.rollback()

# 關閉數(shù)據(jù)庫連接
db.close()

#!/usr/bin/python3
__author__ = 'mayi'

import pymysql

# 打開數(shù)據(jù)庫連接
db = pymysql.connect("localhost","testuser","test123","TESTDB" )

# 使用cursor()方法獲取操作游標 
cursor = db.cursor()

# SQL 刪除語句
sql = "DELETE FROM EMPLOYEE WHERE AGE > '%d'" % (20)
try:
 # 執(zhí)行SQL語句
 cursor.execute(sql)
 # 提交修改
 db.commit()
except:
 # 發(fā)生錯誤時回滾
 db.rollback()

# 關閉連接
db.close()

# SQL刪除記錄語句
sql = "DELETE FROM EMPLOYEE WHERE AGE > '%d'" % (20)
try:
 # 執(zhí)行SQL語句
 cursor.execute(sql)
 # 向數(shù)據(jù)庫提交
 db.commit()
except:
 # 發(fā)生錯誤時回滾
 db.rollback()