Project 2
SQL main file sqlProject2 plus 3 other sql files a,b,c with procedures for Q no 12, 14 and 15 attached
Screenshots for Excel attached
Jupyter file for Qno 4 attached. - Qno4
import mysql.connector
In [4]:
testdb = mysql.connector.connect(
host="localhost",
useimport mysql.connectorr="root",
password="12345",
database="alumni")
testcursor = testdb.cursor()
testcursor.execute("SELECT * FROM colla_hs LIMIT 1000")
for x in testcursor:
print(x)
In [ ]:
testdb = mysql.connector.connect(
host="localhost",
user="root",
password="12345",
database="alumni")
testcursor = testdb.cursor()
testcursor.execute("SELECT * FROM colla_se LIMIT 1000")
for x in testcursor:
print(x)
In [ ]:
testdb = mysql.connector.connect(
host="localhost",
user="root",
password="12345",
database="alumni")
testcursor = testdb.cursor()
testcursor.execute("SELECT * FROM colla_sj LIMIT 1000")
for x in testcursor:
print(x)
In [ ]:
testdb = mysql.connector.connect(
host="localhost",
user="root",
password="12345",
database="alumni")
testcursor = testdb.cursor()
testcursor.execute("SELECT * FROM collb_hs LIMIT 1000")
for x in testcursor:
print(x)
In [ ]:
testdb = mysql.connector.connect(
host="localhost",
user="root",
password="12345",
database="alumni")
testcursor = testdb.cursor()
testcursor.execute("SELECT * FROM collb_se LIMIT 1000")
for x in testcursor:
print(x)
In [ ]:
testdb = mysql.connector.connect(
host="localhost",
user="root",
password="12345",
database="alumni")
testcursor = testdb.cursor()
testcursor.execute("SELECT * FROM collb_sj LIMIT 1000")
for x in testcursor:
print(x)