Python/pymysql

From Wiki
Quick links

Commit()

Changes to the database require a commit(), unless a "with" statement is used!

Examples

  • connect
import pymysql

db = pymysql.connect(host=localhost, port=3306, user="root", password="1234")
  • show version
with db:
    cursor = db.cursor()
    cursor.execute("SELECT VERSION()")
    version = cursor.fetchone()
    print("Database version: {}".format(version[0]))
  • create database
try:
    with db:
        cursor = db.cursor()
        cursor.execute("CREATE DATABASE carsearch")
except Exception as e:
    print(e)

Connection

db = pymysql.connect(host=localhost, port=3306, user="root", password="1234")
  • parameters:
    • host
    • port (default: 3306)
    • user
    • password
    • autocommit (default: false)
  • db.commit()
  • db.close()
  • db.rollback() #rollback current transaction

Cursor

  • cursor.execute("CREATE DATABASE carsearch")
  • cursor.close()
  • cursor.fetchone()
  • cursor.fetchmany()
  • cursor.fetchall()


Documentation