Computer Science
Write code to connect to a MySQL database namely School and then fetch all those records from table Student where grade is ' A' .
Answer
Table Student of MySQL database School
| rollno | name | marks | grade | section | project |
|---|---|---|---|---|---|
| 101 | RUHANII | 76.8 | A | A | PENDING |
| 102 | GEOGRE | 71.2 | B | A | SUBMITTED |
| 103 | SIMRAN | 81.2 | A | B | EVALUATED |
| 104 | ALI | 61.2 | B | C | ASSIGNED |
| 105 | KUSHAL | 51.6 | C | C | EVALUATED |
| 106 | ARSIYA | 91.6 | A+ | B | SUBMITTED |
| 107 | RAUNAK | 32.5 | F | B | SUBMITTED |
import mysql.connector as mysql
db_con = mysql.connect(
host = "localhost",
user = "root",
password = "tiger",
database = "School"
)
cursor = db_con.cursor()
cursor.execute("SELECT * FROM Student WHERE grade = 'A'")
student_records = cursor.fetchall()
for student in student_records:
print(student)
db_con.close()
Output
(101, 'RUHANII', 76.8, 'A', 'A', 'PENDING')
(103, 'SIMRAN', 81.2, 'A', 'B', 'EVALUATED')
Related Questions
Assertion. The cursor rowcount returns how many rows have been retrieved so far through fetch…() methods.
Reason. The number of rows in a resultset and the rowcount are always equal.
What are the steps to connect to a database from within a Python application ?
Predict the output of the following code :
import mysql.connector db = mysql.connector.connect(....) cursor = db.cursor() sql1 = "update category set name = '%s' WHERE ID = %s" % ('CSS',2) cursor.execute(sql1) db.commit() print("Rows affected:", cursor.rowcount) db.close()Explain what the following query will do ?
import mysql.connector db = mysql.connector.connect(....) cursor = db.cursor() person_id = input("Enter required person id") lastname = input("Enter required lastname") db.execute("INSERT INTO staff (person_id, lastname) VALUES ({}, '{}')".format(person_id, lastname)) db.commit() db.close()