Comments (5)
Does pymysql support mysql 5.1? If so should be easy to fix. I will take a
look when, get home
On Sat, Nov 14, 2015, 07:48 llzx373 [email protected] wrote:
In my test,aiomysql not support mysql 5.1, select statement not fetch
result return.What can I do?async def aio_test():
con=await
aiomysql.connect(host='instance_51',port=3306,user='user',password='passwd')
cur=await con.cursor()
await cur.execute('select 1')
res=await cur.fetchone()
print(res)
await cur.close()
con.close()if name == 'main':
loop = asyncio.get_event_loop()
loop.run_until_complete(aio_test())—
Reply to this email directly or view it on GitHub
#38.
from aiomysql.
Looks like mysql 5.1 is not actively supported
http://dba.stackexchange.com/questions/10931/which-version-of-mysql-should-i-use
may be better option is to upgrade?
On Sat, Nov 14, 2015, 11:03 Nickolai Novik [email protected] wrote:
Does pymysql support mysql 5.1? If so should be easy to fix. I will take a
look when, get homeOn Sat, Nov 14, 2015, 07:48 llzx373 [email protected] wrote:
In my test,aiomysql not support mysql 5.1, select statement not fetch
result return.What can I do?async def aio_test():
con=await
aiomysql.connect(host='instance_51',port=3306,user='user',password='passwd')
cur=await con.cursor()
await cur.execute('select 1')
res=await cur.fetchone()
print(res)
await cur.close()
con.close()if name == 'main':
loop = asyncio.get_event_loop()
loop.run_until_complete(aio_test())—
Reply to this email directly or view it on GitHub
#38.
from aiomysql.
In our product env,about 30%(1000+instances) is 5.1.x,upgrade is too hard。In another test,pymyql is work, now,I use gevent+pymysql work well。
But I think asyncio class(aiomysql etc.)is the best practice,fix this bug is very important for me。
thank you。
from aiomysql.
oh, I see, will try to find time on/after weekends.
from aiomysql.
mysql 5.1 is very old, there are little motivation to support it, but PR is welcome
from aiomysql.
Related Issues (20)
- setuptools_scm version 7 generates an incorrect version number for wheels HOT 1
- how to connect using SSH?
- Support SQLAlchemy 1.4
- UNION in SQL causes TypeError: Argument 'val' has incorrect type (expected tuple, got list), in converters.pyx line 23, in asyncmy.converters.escape_item HOT 2
- Automatically handle parallel queries with an async `Lock` HOT 4
- `set-output` in GHA workflow is deprecated
- Better documentation on how connection/cursor work
- The program is blocked for unknown reasons, causing other protocols to fail to run HOT 1
- Connection created from pool is never closed to success after `with` block HOT 2
- Is there any way to release inactive connection?
- Please, type hint this library. HOT 1
- Pre ping failing with uvloop HOT 1
- No fast-track for bulk inserts in Cursor.executemany with INSERT/REPLACE syntax introduced in MySQL 8.0.19
- INSERT into json column on MySQL 8 fails
- Get InternalError: Packet sequence number wrong - got 1 expected 2 HOT 1
- aiomysql returns wrong data when calling pool.acquire multiple times HOT 3
- Similarly, the query results of the sql statements aiomysql and navicat are inconsistent(同样sql语句aiomysql和navicat查询结果不一致) HOT 1
- aiomysql does not work with ssl, but pymysql does work HOT 1
- aiomysql raise InvalidRequestError: Cannot release a connection with not finished transaction
- aiomysql executemany is very slow to insert HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from aiomysql.