Top "Pymysql" questions

PyMySQL is a database connector for Python like MySQLdb.

pyMySQL: How to check if connection is already opened or close

I am getting the error InterfaceError (0, ''). Is there way in Pymysql library I can check whether connection or cursor …

python mysql pymysql
Python mysql (using pymysql) auto reconnect

I'm not sure if this is possible, but I'm looking for a way to reconnect to mysql database when the …

python mysql database-connection connection-pooling pymysql
aiohttp+sqlalchemy: Can't reconnect until invalid transaction is rolled back

I'm using aiohttp and sqlalchemy, and I've created a Singleton that helps me to connect when I'm needed a instance …

python python-3.x sqlalchemy pymysql aiohttp
Python to mysql 'Timestamp' object has no attribute 'translate'

I'm trying to load a pandas dataframe to a mysql table using Sqlalchemy. I connect using; engine = create_engine("mysql+…

python mysql pymysql
AWS Unable to import module 'app' : no module named Pymysql

I am using the AWS Console and trying to add data to a MySQL table using a Lambda function. Whenever …

python amazon-web-services import pymysql
How can I do begin transaction in pymysql ? (mysql)

I want to use run below mysql script using with pymysql. START TRANSACTION; BEGIN; insert into ~~~ COMMIT; my python source …

python mysql pymysql
Is connection.commit() needed after each cursor.execute()?

Is it a valid PyMySQL operation to cursor.execute(…) multiple times before executing connection.commit(), or does connection.commit() need …

pymysql
What exceptions could be returned from Pandas read_sql()

I have a user-defined function that uses pymysql to connect to a mysql database and then it interrogates the database …

python mysql python-3.x pandas pymysql
How to check the status of a mysql connection in python?

I am using pymysql to connect to a database. I am new to database operations. Is there a status code …

python pymysql
PyMySQL throws 'BrokenPipeError' after making frequent reads

I have written a script to help me work with a database. Specifically, I am trying to work with files …

python mysql python-3.x pymysql