Top "Mysql-python" questions

Use this tag for questions about the MySQL-Python database connector library (MySQLdb).

Installing MySQL-python without mysql-server on CentOS

I'm attempting to install MySQL-python on a machine running CentOS 5.5 and python 2.7. This machine isn't running a mysql server, the …

centos mysql-python
Correct exception handling with python MySQLdb connection

I created a small/basic python script to insert data into a MySQL database. I included some error handling - …

python error-handling innodb mysql-python
MySQLdb install error - _mysql.c:44:23: error: my_config.h: No such file or directory

I'm trying to install MySQLdb extension, but I get this error any idea what may be the cause? Could be …

python django mysql-python
Python-mysql: when to explicitly rollback a transaction

Suppose, I have a modifying statement: cursor = conn.cursor() # some code affected_rows1 = cursor.execute(update_statement1, params1) # some code …

python mysql mysql-python
/usr/bin/ld: cannot find -lpython2.7

I'm trying to install MySQLdb with Python 2.7. The error I'm getting looks like this: gcc -pthread -fno-strict-aliasing -g -O2 -DNDEBUG …

python linux mysql-python
How to install python2.6-devel package under CentOs 5

I need to install mysql-python under python2.6. mysql-python package needs python2.6-devel package that depends on the libpython2.6.so.1.0(64bit) …

x86-64 python-2.6 centos5 mysql-python
Installing PyMySQL on a Windows 7 machine

I am not a python user and though I have used MySQL, I'm not an expert. Also, I'm mainly a …

python python-3.x mysql-python pymysql
Python MySQLdb iterate through table

I have a MSQL db and I need to iterate through a table and perform an action once a WHERE …

python mysql mysql-python
Python mySQL - escaping quotes

I have seen this question asked in various ways on this website, but none of them exactly addressed my issue. …

python mysql mysql-python
What's the most efficient way to convert a MySQL result set to a NumPy array?

I'm using MySQLdb and Python. I have some basic queries such as this: c=db.cursor() c.execute("SELECT id, …

python numpy mysql-python etl