This package contains a python MySQL client library.
It is a fork project from PyMySQL http://www.pymysql.org/ .
PyMySQL is written by Yutaka Matsubara <[email protected]> as a pure python database driver.
CyMySQL accerarates by Cython, and support not only python 2 but also python 3. It still can work without Cython as a pure python driver.
It is maintained by Hajime Nakagami <[email protected]>.
Documentation on the MySQL client/server protocol can be found here: http://dev.mysql.com/doc/internals/en/client-server-protocol.html
- Python 2.6 or higher
- Cython 0.22 or higher
- MySQL 4.1 or higher
Install cython (optional) :
# pip install cython
Install cymysql :
# pip install cymysql
Example :
import cymysql
conn = cymysql.connect(host='127.0.0.1', user='root', passwd='', db='database_name', charset='utf8')
cur = conn.cursor()
cur.execute('select foo, bar from baz')
for r in cur.fetchall():
print(r[0], r[1])