Project 2

import mysql.connector
testdb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="marcianjermy682!",
  database = "alumni")
testcursor = testdb.cursor()
testcursor.execute("SELECT * FROM college_a_hs LIMIT 1000")
for i in testcursor:
    print(i)
    
testcursor.execute("SELECT * FROM college_a_se LIMIT 1000")
for i in testcursor:
    print(i)
    
testcursor.execute("SELECT * FROM college_a_sj LIMIT 1000")
for i in testcursor:
    print(i)
    
testcursor.execute("SELECT * FROM college_b_hs LIMIT 1000")
for i in testcursor:
    print(i)
    
testcursor.execute("SELECT * FROM college_b_se LIMIT 1000")
for i in testcursor:
    print(i)
    
testcursor.execute("SELECT * FROM college_b_sj LIMIT 1000")
for i in testcursor:
    print(i)