Select

import sys

import mysql.connector as mc

try:

connection = mc.connect (host = "localhost",

user = "pytester",

passwd = "monty",

db = "company")

except mc.Error as e:

print("Error %d: %s" % (e.args[0], e.args[1]))

sys.exit(1)

cursor = connection.cursor()

cursor.execute("SELECT * FROM employee")

print('''Result of "SELECT * FROM employee":''')

result = cursor.fetchall()

for r in result:

print(r)

cursor.close()

connection.close()