27 lines
573 B
Python
27 lines
573 B
Python
#!/usr/bin/env python
|
|
|
|
from contextlib import closing
|
|
import pymysql
|
|
|
|
with closing(
|
|
pymysql.connect(
|
|
host="localhost",
|
|
db="presidents",
|
|
user="scripts",
|
|
passwd="scripts",
|
|
)
|
|
) as myconn:
|
|
mycursor = myconn.cursor()
|
|
|
|
# select first name, last name from all presidents
|
|
row_count = mycursor.execute('''
|
|
select firstname, lastname
|
|
from presidents
|
|
''')
|
|
|
|
print("{} rows in result set\n".format(row_count))
|
|
|
|
for firstname, lastname in mycursor.fetchall():
|
|
print(firstname, lastname)
|
|
print()
|