mysql connector 2fpython query example

1Press CTRL+C to copy import datetime
2import mysql.connector
3
4cnx = mysql.connector.connect(user='scott', database='employees')
5cursor = cnx.cursor()
6
7query = ("SELECT first_name, last_name, hire_date FROM employees "
8         "WHERE hire_date BETWEEN %s AND %s")
9
10hire_start = datetime.date(1999, 1, 1)
11hire_end = datetime.date(1999, 12, 31)
12
13cursor.execute(query, (hire_start, hire_end))
14
15for (first_name, last_name, hire_date) in cursor:
16  print("{}, {} was hired on {:%d %b %Y}".format(
17    last_name, first_name, hire_date))
18
19cursor.close()
20cnx.close()