Top "Pymysql" questions

PyMySQL is a database connector for Python like MySQLdb.

No module named 'pymysql'

I'm trying to use PyMySQL on Ubuntu. I've installed pymysql using both pip and pip3 but every time I use …

python python-3.x ubuntu pymysql
How to insert data to django database from views.py file?

How can I insert data to my django database from a function in the views,py file? Is python manage.…

python django django-models django-views pymysql
Using python to write mysql query to csv, need to show field names

I have the following: import MySQLdb as dbapi import sys import csv dbServer='localhost' dbPass='supersecretpassword' dbSchema='dbTest' dbUser='root' …

python mysql csv mariadb pymysql
Pymysql Insert Into not working

I'm running this from PyDev in Eclipse... import pymysql conn = pymysql.connect(host='localhost', port=3306, user='userid', passwd='password', db=…

python mysql eclipse python-2.7 pymysql
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
Select query in pymysql

When executing the following: import pymysql db = pymysql.connect(host='localhost', port=3306, user='root') cur = db.cursor() print(cur.execute("…

python sql pymysql
How to get the MySQL type of error with PyMySQL?

I'm doing a Python application with MySQL and PyMySQL and I'd like to be able to know the number of …

python mysql pymysql
PyMysql UPDATE query

I've been trying using PyMysql and so far everything i did worked (Select/insert) but when i try to update …

python mysql sql-update pymysql
How to copy a database with mysqldump and mysql in Python?

I am writing a simple Python script to copy a MySQL database. I am attempting to copy the database based …

python mysql subprocess mysqldump pymysql
pyMySQL set connection character set

I'm developing a fairly straightforward web app using Flask and MySQL. I'm struggling with unicode. Users sometimes paste stuff that …

python mysql unicode pymysql