Project 2

Q4

import mysql.connector

testdb=mysql.connector.connect(

database="Alumni",

host="localhost",

user="root",

port="3305",

password="login@123"

)

cursor=testdb.cursor()

cursor.execute("select * from College_B_SJ limit 1000;")

for x in cursor:

print(x)