Utilisateur:Ghuard : Différence entre versions
| (Une révision intermédiaire par le même utilisateur non affichée) | |||
| Ligne 1: | Ligne 1: | ||
Installation de pip via github | 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) | 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 | pip install Mysql-python | ||
| + | |||
| + | |||
Voici un exemple de l'utilisation de consultation de bas de données avec query | Voici un exemple de l'utilisation de consultation de bas de données avec query | ||
import datetime | import datetime | ||
| + | |||
import mysql.connector | import mysql.connector | ||
cnx = mysql.connector.connect(user='scott', database='employees') | cnx = mysql.connector.connect(user='scott', database='employees') | ||
| + | |||
cursor = cnx.cursor() | cursor = cnx.cursor() | ||
query = ("SELECT first_name, last_name, hire_date FROM employees " | query = ("SELECT first_name, last_name, hire_date FROM employees " | ||
"WHERE hire_date BETWEEN %s AND %s") | "WHERE hire_date BETWEEN %s AND %s") | ||
| + | |||
hire_start = datetime.date(1999, 1, 1) | hire_start = datetime.date(1999, 1, 1) | ||
| + | |||
hire_end = datetime.date(1999, 12, 31) | hire_end = datetime.date(1999, 12, 31) | ||
cursor.execute(query, (hire_start, hire_end)) | cursor.execute(query, (hire_start, hire_end)) | ||
| + | |||
for (first_name, last_name, hire_date) in cursor: | for (first_name, last_name, hire_date) in cursor: | ||
| + | |||
print("{}, {} was hired on {:%d %b %Y}".format( | print("{}, {} was hired on {:%d %b %Y}".format( | ||
last_name, first_name, hire_date)) | last_name, first_name, hire_date)) | ||
cursor.close() | cursor.close() | ||
| + | |||
cnx.close() | cnx.close() | ||
Version actuelle datée du 9 de janvier 2018 à 19:51
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()
