pymysql使用表的例子

首先在mysql数据库中创建一张表：

CREATE TABLE `users` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`email` varchar(255) COLLATE utf8_bin NOT NULL,

`password` varchar(255) COLLATE utf8_bin NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin

AUTO_INCREMENT=1 ;

用pymysql连接数据库，并操作上面的表：

import pymysql.cursors

# 连接到本地的数据库，如果连接远端数据库，输入ip地址

connection = pymysql.connect(host='localhost',

user='user',

password='passwd',

db='db',

charset='utf8mb4',

cursorclass=pymysql.cursors.DictCursor)

try:

with connection.cursor() as cursor:

#创建一个新的记录

sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"

cursor.execute(sql, ('webmaster@python.org', 'very-secret'))

# 缺省不会自动提交，因此你需要提交并保存你的改变..

connection.commit()

with connection.cursor() as cursor:

# 选择一条记录

sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"

cursor.execute(sql, ('webmaster@python.org',))

result = cursor.fetchone()

print(result)

finally:

connection.close()

文章来源：http://pymysql.readthedocs.io/en/latest/user/examples.html