MySQLdb FAQ

Andy Dustman

1. Compiling _mysql.so

• 1.1 ImportError: libmysqlclient.so.6: cannot open shared object file:
• 1.2 ImportError: ./_mysql.so: undefined symbol: PyLong_FromUnsignedLongLong
• 1.3 ImportError: ./_mysql.so: undefined symbol: uncompress
• 1.4 ./_mysql.c:33: mysql.h: No such file or directory
• 1.5 I'm using Windows...

2. Trouble with ZMySQLDA

• 2.1 I installed MySQLdb but ZMySQLDA can't find it.
• 2.2 I'm getting these stupid L's on my INTEGER columns.
• 2.3 I get SQL syntax errors on a LIMIT clause, and I didn't put in

3. Using MySQLdb

• 3.1 cursor.rollback() always fails!
• 3.2 How do I use some of the special MySQL features?
• 3.3 I still wanna use _mysql directly.