操作MySql

原创于 2015-07-31 23:32:50 发布 · 542 阅读

0 ·

CC 4.0 BY-SA版权

pyThon 专栏收录该内容

24 篇文章

订阅专栏

本文介绍了如何使用pyMySQL模块连接并操作MySQL数据库，包括安装配置、基本查询等操作示例。

1.使用pyMySQL操作数据库,下载

点击打开链接

2.解压后在跟目录

py setup.py install

重启一下py shell

3.例子

import pymysql.cursors
connection = pymysql.connect(host='localhost',user='root',
                             password='111111',db='pyDB',
                             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 * FROM USERS U WHERE U.ID > 0'
        cursor.execute(sql)
        result = cursor.fetchone()
        print(result)
finally:
        connection.close()

参考资料：

Resources

DB-API 2.0: http://www.python.org/dev/peps/pep-0249

MySQL Reference Manuals: http://dev.mysql.com/doc/

MySQL client/server protocol: http://dev.mysql.com/doc/internals/en/client-server-protocol.html

PyMySQL mailing list: https://groups.google.com/forum/#!forum/pymysql-users