Python MySQL

Posted by On 12月 24, 2015 0 Comment

Library

There are a lot of library for MySQL.

In Python3, PyMySQL is a bit good, I thought.

PyMySQL

Python
Github
Github link has easy description how to use it. It is useful guide to write program.

Install

PyMySQL is PyPI index. Try following if you have PyPI

pip install PyMySQL

Sample Program

import pymysql.cursors

connection = pymysql.connect(host='localhost',
                             user='root',
                             password='',
                             db='sampledb')


try:
    with connection.cursor() as cursor:
        # CREATE TABLE
        sql = "CREATE TABLE IF NOT EXISTS items(id int, name varchar(100), price int);"
        cursor.execute(sql)
    connection.commit()

    # Insert
    with connection.cursor() as cursor:
        sql = "INSERT INTO `items` (`id`, `name`, `price`) VALUES (%s, %s, %s)"
        cursor.execute(sql, ('2', 'ABC', '200'))
    connection.commit()

    # Select

    with connection.cursor() as cursor:
        # Read
        sql = "SELECT * FROM `items`;"
        cursor.execute(sql)
        for row in cursor:
            print(row)

finally:
    connection.close()

TOPICS