Voir la source de Utilisateur:Ghuard

Installation de pip via github

export PATH=/usr/local/mysql-5.7.9-osx10.9-x86_64/bin/:$PATH (Changer selon la version de mysql installée)

pip install Mysql-python



Voici un exemple de l'utilisation de consultation de bas de données avec query

import datetime

import mysql.connector

cnx = mysql.connector.connect(user='scott', database='employees')

cursor = cnx.cursor()

query = ("SELECT first_name, last_name, hire_date FROM employees "
"WHERE hire_date BETWEEN %s AND %s")

hire_start = datetime.date(1999, 1, 1)

hire_end = datetime.date(1999, 12, 31)

cursor.execute(query, (hire_start, hire_end))

for (first_name, last_name, hire_date) in cursor:

print("{}, {} was hired on {:%d %b %Y}".format(
last_name, first_name, hire_date))

cursor.close()

cnx.close()