(Python,MySQL)DBアクセスサンプル

C:\Users\masawa>pip install mysql-connector-python

import mysql.connector

config = {
    "host": "localhost", 
    "database": "test_db", 
    "user": "masawa", 
    "password": "masawa"
}

conn = mysql.connector.connect(**config)
cursor = conn.cursor()

cursor.execute("SELECT * FROM persons;")
persons = cursor.fetchall()

for row in persons:
    print("id: {}, name: {}".format(row[0], row[1]))

cursor.close()
conn.close()