import mysql.connector
 
mycon = mysql.connector.connect(
            host='localhost',
            user='root',
            password='password', 
            database='School')   
 
if  mycon.is_connected():
    print('Database connected')
 
cursor = mycon.cursor()
 
# Display all the records of students in ascending order of Name:
 
sql ="SELECT * FROM STUDENT ORDER BY Name"
cursor.execute(sql)
data = cursor.fetchall()
print("Answer for a):")
 
for rec in data: 
print(rec)
 
 
 
# Display the number of records whose name starts with 'D':
 
sql ="SELECT COUNT(*) FROM STUDENT WHERE Name LIKE 
         'D%'"
cursor.execute(sql)
count = cursor.fetchone()[0]
print("The number of records whose name starts with 'D' is{count}")
 
# Delete the record whose ID is 3
 
sql ="DELETE FROM STUDENT WHERE ID =3"
cursor.execute(sql)
mycon.commit()
print("Record Deleted")
 
mycon.close()
 

aW1wb3J0IG15c3FsLmNvbm5lY3RvcgoKbXljb24gPSBteXNxbC5jb25uZWN0b3IuY29ubmVjdCgKICAgICAgICAgICAgaG9zdD0nbG9jYWxob3N0JywKICAgICAgICAgICAgdXNlcj0ncm9vdCcsCiAgICAgICAgICAgIHBhc3N3b3JkPSdwYXNzd29yZCcsIAogICAgICAgICAgICBkYXRhYmFzZT0nU2Nob29sJykgICAKCmlmICBteWNvbi5pc19jb25uZWN0ZWQoKToKICAgIHByaW50KCdEYXRhYmFzZSBjb25uZWN0ZWQnKQoKY3Vyc29yID0gbXljb24uY3Vyc29yKCkKCiMgRGlzcGxheSBhbGwgdGhlIHJlY29yZHMgb2Ygc3R1ZGVudHMgaW4gYXNjZW5kaW5nIG9yZGVyIG9mIE5hbWU6CgpzcWwgPSJTRUxFQ1QgKiBGUk9NIFNUVURFTlQgT1JERVIgQlkgTmFtZSIKY3Vyc29yLmV4ZWN1dGUoc3FsKQpkYXRhID0gY3Vyc29yLmZldGNoYWxsKCkKcHJpbnQoIkFuc3dlciBmb3IgYSk6IikKCmZvciByZWMgaW4gZGF0YTogCnByaW50KHJlYykKCgoKIyBEaXNwbGF5IHRoZSBudW1iZXIgb2YgcmVjb3JkcyB3aG9zZSBuYW1lIHN0YXJ0cyB3aXRoICdEJzoKCnNxbCA9IlNFTEVDVCBDT1VOVCgqKSBGUk9NIFNUVURFTlQgV0hFUkUgTmFtZSBMSUtFIAogICAgICAgICAnRCUnIgpjdXJzb3IuZXhlY3V0ZShzcWwpCmNvdW50ID0gY3Vyc29yLmZldGNob25lKClbMF0KcHJpbnQoIlRoZSBudW1iZXIgb2YgcmVjb3JkcyB3aG9zZSBuYW1lIHN0YXJ0cyB3aXRoICdEJyBpc3tjb3VudH0iKQoKIyBEZWxldGUgdGhlIHJlY29yZCB3aG9zZSBJRCBpcyAzCgpzcWwgPSJERUxFVEUgRlJPTSBTVFVERU5UIFdIRVJFIElEID0zIgpjdXJzb3IuZXhlY3V0ZShzcWwpCm15Y29uLmNvbW1pdCgpCnByaW50KCJSZWNvcmQgRGVsZXRlZCIpCgpteWNvbi5jbG9zZSgpCg==