36 lines
1.0 KiB
Python
36 lines
1.0 KiB
Python
import pymysql
|
|
|
|
# pip3 install PyMySQL
|
|
# http://zetcode.com/python/pymysql/
|
|
|
|
con = pymysql.connect('localhost', 'root', 'sncfp1p2', 'python')
|
|
|
|
with con:
|
|
|
|
cursor = con.cursor()
|
|
|
|
cursor.execute("SELECT VERSION()")
|
|
version = cursor.fetchone()
|
|
print("Database version: {}".format(version[0]))
|
|
|
|
name = "bruno"
|
|
age = 50
|
|
|
|
# cursor.execute("""SELECT id, name, age FROM visiteurs WHERE name = %s""", (name, ))
|
|
cursor.execute("""SELECT id, name, age FROM visiteurs WHERE name = %s AND age = %s""", (name,age))
|
|
|
|
rows = cursor.fetchall()
|
|
for row in rows:
|
|
print('{0} : {1} - {2}'.format(row[0], row[1], row[2]))
|
|
|
|
print("The query affected {} rows".format(cursor.rowcount))
|
|
|
|
#age = 35
|
|
# cursor.execute("""SELECT id, name, age FROM visiteurs WHERE age < %s""", (age))
|
|
cursor.execute("""SELECT id, name, age FROM visiteurs ORDER BY age LIMIT 1""")
|
|
jeune = cursor.fetchone()
|
|
print("Le + jeune : {0} - {1} - {2}".format(jeune[0], jeune[1], jeune[2]))
|
|
|
|
print("The query affected {} rows".format(cursor.rowcount))
|
|
|