Tagged Questions
43
votes
5answers
38k views
How to install MySQLdb (Python data access library to MySQL) on Mac OS X?
I'm a Python newbie, but I've just spent a day working out how to get MySQLdb working properly, and the universe according to google includes numerous references to what a PITA it is, and an ...
75
votes
14answers
54k views
MySQL for Python in Windows
I am finding it difficult to use MySQL with Python in my windows system.
I am currently using Python 2.6. I have tried to compile MySQL-python-1.2.3b1 (which is supposed to work for Python 2.6 ?) ...
120
votes
7answers
71k views
How do I connect to a MySQL Database in Python?
How do I connect to a MySQL database using a python program?
32
votes
3answers
12k views
Whether to use “SET NAMES”
In reading "High performance MySQL" from O'Reilly I've stumbled upon the following
Another common garbage query is SET
NAMES UTF8, which is the wrong way to
do things anyway (it does not ...
8
votes
5answers
10k views
mysql-python installation problems (on mac os x lion)
I installed everything successfully, or so I thought:
MySQL 5.5 for x86_64.
Python 2.7, x86_64.
mysql-python 1.2.3, x86_64.
But when I try:
import MySQLdb
I get:
ImportError:
...
7
votes
3answers
8k views
Python import MySQLdb error - Mac 10.6
I downloaded and followed the install instructions for MySQL 5.5.8 (http://dev.mysql.com/downloads/mysql/) and for the MySQLdb python plugin. (http://sourceforge.net/projects/mysql-python/)
When I ...
20
votes
7answers
11k views
Does Python support MySQL prepared statements?
I worked on a PHP project earlier where prepared statements made the SELECT queries 20% faster.
I'm wondering if it works on Python? I can't seem to find anything that specifically says it does or ...
34
votes
6answers
21k views
MySQL “incorrect string value” error when save unicode string in Django
I got strange error message when tried to save first_name, last_name to Django's auth_user model.
Failed examples
user = User.object.create_user(username, email, password)
user.first_name = u'Rytis'
...
30
votes
4answers
15k views
Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
The setup...
Trying to set up a clean Mac os X 10.6 install to develop python/django and I didn't remember running into this on 10.5.
After installing MySQL from the installer on ...
4
votes
9answers
782 views
To make a plan for my first MySQL project
I need to complete the plan of a ask-a-question site for my uni. in a few days. I need to have the first version of the code ready for the next Tuesday, while the end of the project is in about three ...
9
votes
3answers
9k views
Django + MySQL on Mac OS 10.6.2 Snow Leopard
There were some excellent answers to this question already, however, they are now outdated.
I've been able to get the module installed, but "python manage.py runserver" fails with
iMac:myproject ...
13
votes
6answers
21k views
Python mysql with variables
I am having a hard time using the MySQLdb module to insert information into my database. I need to insert 6 variables into the table.
cursor.execute ("""
INSERT INTO Songs (SongName, ...
17
votes
10answers
15k views
Python MySQL wrong architecture error
I've been at this for some time and read many sites on the subject. suspect I have junk lying about causing this problem. But where?
This is the error when I import MySQLdb in python:
>>> ...
6
votes
5answers
19k views
Lost connection to MySQL server during query
I have a huge table and I need to process all rows in it. I'm always getting this Lost connection message and I'm not able to reconnect and restore the cursor to the last position it was. This is ...
13
votes
8answers
14k views
MySQL-db lib for Python 3.0?
So, looking for a mysql-db-lib that is compatible with py3k/py3.0/py3000, any ideas? google turned up nothing.
