Top "Mysql-python" questions

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

How to use python mysqldb to insert many rows at once

I have a list of lists, e.g [['a','b'],['c','d']]. I have a table called T and two …

python mysql mysql-python
ERROR 2006 (HY000) at line 1: MySQL server has gone away

ERROR 2006 (HY000) at line 1: MySQL server has gone away I am facing the same problem. I am trying to restore …

mysql mysql-python
Python error: command '...\Microsoft Visual Studio 10.0\\VC\\BIN\\cl.exe' failed with exit status 2

I have some problems with python 3 module installing. I'm trying to install mysql using pip : python -m pip install mysql …

visual-studio-2010 python-3.x pip mysql-python
Python: ValueError: unsupported format character ''' (0x27) at index 1

I'm trying to execute a query to search 3 tables in a database using MySQL through Python. Every time I try …

python mysql mysql-python
How to retrieve table names in a mysql database with Python and MySQLdb?

I have an SQL database and am wondering what command you use to just get a list of the table …

python mysql mysql-python
What is PyMySQL and how does it differ from MySQLdb? Can it affect Django deployment?

I just solved some problems in my Django 1.3 app by using PyMySQL instead of MySQLdb. I followed this tutorial on …

python mysql django mysql-python pymysql
MySQLdb.cursor.execute can't run multiple queries

We're trying to run SQL files containing multiple insert statements as a single query, but it seems rollback fails when …

python mysql mysql-python
How can I use Conda to install MySQLdb?

I've read several different explanation regarding how to install MySQLdb, but I'm not sure which case applies to me since …

python mysql mysql-python
Python 3.7, Failed building wheel for MySql-Python

I am new to python and I am trying django framework that involves some MySql and ran into this error …

python mysql django python-3.x mysql-python
How can I use executemany to insert into MySQL a list of dictionaries in Python

I'm currently using MySQL and Python to scrape data from the web. Specifically, I am scraping table data and inserting …

python mysql mysql-python