Tagged Questions

A thread-compatible interface to the popular MySQL database server that provides the Python database API.

learn more… | top users | synonyms (1)

0
votes
0answers
11 views

MySQL tornado with python flask [closed]

I am using python flask. How do I establish connection with my MySQL database.
0
votes
1answer
28 views

How to access a database in Django but without ORM support

I have a second database in my Django application, which is filled with static data about the equivalent of zipcodes in my country (Brazil) and the related streets, neighborhoods, cities and states. ...
0
votes
1answer
15 views

Joining tables through Python MySQLdb

I am a recent user of python and MySQLdb and I want to know why I am unable to recieve a result by running a sql query in python. The query I ran was: "SELECT dividend FROM Dividends, Avatar_recs ...
1
vote
5answers
35 views

python mysqldb import error

on ubuntu i have installed mysql but still i cannot import mysql database. Below are the steps that i followed.Can any one point me to a solution to this (Other info is ubuntu is installed on a ...
1
vote
2answers
41 views

Scrapy mysql pipeline critical section in runInteraction()

I need to help with fixing critical section in my pipeline scrapy code. I am using this MySQL pipeline in scrapy (from http://snippets.scrapy.org/snippets/33/): class SQLStorePipeline(object): def ...
0
votes
3answers
26 views

Python MySQLdb : Duplicate entry '2147483647' for key 1

I am getting this error when I run my program in Python. Here's the table of my database : Field Type Collation Null Key Default articleCode varchar(25) ...
0
votes
1answer
19 views

SELECT UNCOMPRESS(text) FROM with sqlalchemy

I store the MySQL Compress function to insert compressed blob data to the database. In a previous question I was instructed to to use func.compress ( mysql Compress() with sqlalchemy ) The ...
0
votes
1answer
20 views

Mac Lion Python install: Matplotlib ends in mysql error

I am setting up python/numpy/scipy/matplotlib/mysql on my Mac Lion. I first installed Python 2.7.3 and mysqldb. I then updated to XCode 4.3.3 and used the ScipySuperpack to install numpy, scipy, etc. ...
0
votes
1answer
28 views

How to import sql.gz file to mysql database using python script?

I export database using mysqldump command in sql.gz format using python script. How to import sql.gz file using using python script? I wrote code which works for .sql or .txt files. import MySQLdb ...
0
votes
1answer
25 views

Is it possible to execute MySQLdb executemany function using a mapping(dictionary)

I know that we can use executemany this way: sql = "insert into a(c1,c2,c3) values(%s,%s,%s)" seq_of_parameters = [('a','b','c'),('a','b','c')] cu.executemany(sql,seq_of_parameters) I wonder why ...
0
votes
0answers
9 views

setting up mysql-python on Snow Leopard

I have successfully installed py27-mysql from MacPorts and MySQL-python-1.2.3c1 on a machine running Snow Leopard. Because I have MySQL 5.1.48 in an odd location (/usr/local/mysql/bin/mysql/), I had ...
1
vote
0answers
14 views

DB-API Type_Codes for Google Cloud Sql: Different from MySQLdb?

I'm finding that the type_codes returned by cursor.description from DB-API are different for Google Cloud SQL than a standard MySQLdb implementation. For example: in MySQLdb (mysqldb-python), ...
0
votes
0answers
54 views

Django DB transactions and deadlocks

When running Django with Gunicorn with multiple processes/workers I'm getting a deadlock issue with some of my manual MySQL database transactions. DatabaseError(1205, 'Lock wait timeout exceeded; try ...
0
votes
2answers
25 views

To check varchar values and avoid duplicate entries in MySQL table

I need to run a application to collect the news feeds and update new entries in my database. So I planned to create two tables one source and other as target. My plan is to first update all the ...
0
votes
1answer
47 views

Why isn't MySQLdb installation working on my 64bit Mac

>>> import MySQLdb Traceback (most recent call last): File "<stdin>", line 1, in <module> File "build/bdist.macosx-10.6-intel/egg/MySQLdb/__init__.py", line 19, in ...

1 2 3 4 5 … 23
15 30 50 per page