GitHub - linliangbin00/PyMySQL: Pure Python MySQL Client

linliangbin00/PyMySQL

Folders and files

Name		Name	Last commit message	Last commit date
Latest commit History 860 Commits
.github		.github
.travis		.travis
docs		docs
pymysql		pymysql
.coveragerc		.coveragerc
.gitignore		.gitignore
.travis.yml		.travis.yml
CHANGELOG		CHANGELOG
LICENSE		LICENSE
MANIFEST.in		MANIFEST.in
README.rst		README.rst
example.py		example.py
runtests.py		runtests.py
setup.cfg		setup.cfg
setup.py		setup.py
tox.ini		tox.ini

Repository files navigation

Documentation Status https://travis-ci.org/PyMySQL/PyMySQL.svg?branch=master https://coveralls.io/repos/PyMySQL/PyMySQL/badge.svg?branch=master&service=github

PyMySQL

Table of Contents

Requirements
Installation
Documentation
Example
Resources
License

This package contains a pure-Python MySQL client library, based on PEP 249.

Most public APIs are compatible with mysqlclient and MySQLdb.

NOTE: PyMySQL doesn't support low level APIs _mysql provides like data_seek, store_result, and use_result. You should use high level APIs defined in PEP 249. But some APIs like autocommit and ping are supported because PEP 249 doesn't cover their usecase.

Requirements

Python -- one of the following:
- CPython : 2.7 and >= 3.4
- PyPy : Latest version
MySQL Server -- one of the following:
- MySQL >= 5.5
- MariaDB >= 5.5

Installation

Package is uploaded on PyPI.

You can install it with pip:

$ pip3 install PyMySQL

Documentation

Documentation is available online: https://pymysql.readthedocs.io/

For support, please refer to the StackOverflow.

Example

The following examples make use of a simple table

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 ;

import pymysql.cursors
# Connect to the database
connection = pymysql.connect(host='localhost',
 user='user',
 password='passwd',
 db='db',
 charset='utf8mb4',
 cursorclass=pymysql.cursors.DictCursor)
try:
 with connection.cursor() as cursor:
 # Create a new record
 sql = "INSERT INTO `users` (`email`, `password`) VALUES (%s, %s)"
 cursor.execute(sql, ('webmaster@python.org', 'very-secret'))
 # connection is not autocommit by default. So you must commit to save
 # your changes.
 connection.commit()
 with connection.cursor() as cursor:
 # Read a single record
 sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
 cursor.execute(sql, ('webmaster@python.org',))
 result = cursor.fetchone()
 print(result)
finally:
 connection.close()