pymysqlを使用してPythonからMySQLを操作します。
- インストール
pip install PyMySQL
- スクリプト例
import pymysql.cursors ## connect connection = pymysql.connect( host = 'localhost', user = 'hoge', password = 'hogehoge', db = 'hoge_db', charset = 'utf8', cursorclass = pymysql.cursors.DictCursor # 実行結果をDictで返す ) ## select with connection.cursor() as cursor: sql = "SELECT * FROM hoge_table WHERE id = %s" cursor.execute(sql, 4) results = cursor.fetchall() ## insert with connection.cursor() as cursor: sql = "INSERT INTO hoge_table (id, name) VALUES (%s, %s)" res = cursor.execute(sql, (5, "huga")) connection.commit() # 保存知るためには明示的に指定 ## update with connection.cursor() as cursor: sql = "UPDATE hoge_table SET name = %s WHERE id = %s" res = cursor.execute(sql, ("hugahuga", "5")) connection.commit()