Connect MySQL with Python 3.6

python mysql database raspberry-pi
no0by5 picture no0by5 · Feb 28, 2017 · Viewed 62.1k times · Source

I'm looking for a library to connect to MySQL with Python 3.6. All libraries I found did only work with older versions of Python. Sadly I can't change to an older Python version because i need some functions, which are introduced in Python 3.6.

I am programming on a raspberry pi3, but I don't think this should change anything.

Thanks for any help!

Answer

Beomi picture Beomi · Feb 28, 2017

mysqlclient supports python3.6 officially.

https://pypi.python.org/pypi/mysqlclient

Related questions

How do I get the "id" after INSERT into MySQL database with Python?

I execute an INSERT INTO statement cursor.execute("INSERT INTO mytable(height) VALUES(%s)",(height)) and I want to get the primary key. My table has 2 columns: id primary, auto increment height this is the other column. How do I …

Read More
Bulk insert with SQLAlchemy ORM

Is there any way to get SQLAlchemy to do a bulk insert rather than inserting each individual object. i.e., doing: INSERT INTO `foo` (`bar`) VALUES (1), (2), (3) rather than: INSERT INTO `foo` (`bar`) VALUES (1) INSERT INTO `foo` (`bar`) VALUES (2) INSERT INTO `…

Read More
Switching from SQLite to MySQL with Flask SQLAlchemy

I have a site that I've built with Flask SQLAlchemy and SQLite, and need to switch to MySQL. I have migrated the database itself and have it running under MySQL, but Can't figure out how to connect to the MySQL …

Read More