MySQLdb does not support Python 3 but it is not the only MySQL driver for Python. mysqlclient is essentially just a fork of MySQLdb with Python 3 support merged in (and a few other improvements). PyMySQL is a pure python MySQL driver, which means it is slower, but it does not require a compiled C … Read more
And what about list comprehensions? If result is ((123,), (234,), (345,)): >>> row = [item[0] for item in cursor.fetchall()] >>> row [123, 234, 345] If result is ({‘id’: 123}, {‘id’: 234}, {‘id’: 345}): >>> row = [item[‘id’] for item in cursor.fetchall()] >>> row [123, 234, 345]
Probably one of the indices is wrong, either the inner one or the outer one. I suspect you meant to say [0] where you said [1], and [1] where you said [2]. Indices are 0-based in Python.
Update: There is now a to_sql method, which is the preferred way to do this, rather than write_frame: df.to_sql(con=con, name=”table_name_for_df”, if_exists=”replace”, flavor=”mysql”) Also note: the syntax may change in pandas 0.14… You can set up the connection with MySQLdb: from pandas.io import sql import MySQLdb con = MySQLdb.connect() # may need to add some other … Read more
All I had to do was go over to oracle, and download the MySQL Connector C 6.0.2 (newer doesn’t work!) and do the typical install. https://downloads.mysql.com/archives/c-c/ Be sure to include all optional extras (Extra Binaries) via the custom install, without these it did not work for the win64.msi Once that was done, I went into … Read more
for 64-bit windows install using wheel pip install wheel download from http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python For python 3.x: pip install mysqlclient-1.3.8-cp36-cp36m-win_amd64.whl For python 2.7: pip install mysqlclient-1.3.8-cp27-cp27m-win_amd64.whl
We found an attribute on the cursor object called cursor._last_executed that holds the last query string to run even when an exception occurs. This was easier and better for us in production than using profiling all the time or MySQL query logging as both of those have a performance impact and involve more code or more … Read more
Instead of asking what is standard practice, since that’s often unclear and subjective, you might try looking to the module itself for guidance. In general, using the with keyword as another user suggested is a great idea, but in this specific circumstance it may not give you quite the functionality you expect. As of version … Read more
I will re-iterate the best practice at everyone who comes across the sql connection using MySQLdb or any other package to connect python2/3 needs to know this (Following mock run assumes that you have a table named tablename in your sql database. It has got 4 columns/fields with names field1,field2,field3,field4). If your connection is local … Read more
cursor.description will give you a tuple of tuples where [0] for each is the column header. num_fields = len(cursor.description) field_names = [i[0] for i in cursor.description]