Python subjective question(Database) for competitive exam (24)

Q1 Insert data in mysql database using cursor.

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="myusername",
  password="mypassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

sql = "INSERT INTO student (name, address) VALUES (%s, %s)"
val = ("John", "h.no 21")

mycursor.execute(sql, val)

mydb.commit()

print(mycursor.rowcount, "record inserted.")

Output
1 record inserted.

Q2.Insert multiple row data in mysql database using cursor.

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="myusername",
  password="mypassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

sql = "INSERT INTO student (name, address) VALUES (%s, %s)"
val = [
 ('Peter', 'Lowstreet 4'),
 ('Amy', 'Apple st 652'),
 ('Hannah', 'Mountain 21'),
 ('Michael', 'Valley 345'),
 ('Sandy', 'Ocean blvd 2'),
 ('Betty', 'Green Grass 1'),
 ('Richard', 'Sky st 331'),
 ('Susan', 'One way 98'),
 ('Vicky', 'Yellow Garden 2'),
 ('Ben', 'Park Lane 38')
]

mycursor.executemany(sql, val)

mydb.commit()

print(mycursor.rowcount, "record was inserted.")

Output
10 record was inserted.

Q3.Update data in mysql database using cursor.

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

sql = "UPDATE student SET address = 'Canyon 123' WHERE address = 'Valley 345'"

mycursor.execute(sql)

mydb.commit()

print(mycursor.rowcount, "record(s) affected")

Output
1 record(s) affected

Q4.Retrive one record from mysql database using cursor.

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

mycursor.execute("SELECT * FROM student")

myresult = mycursor.fetchone()

print(myresult)

Output
('Peter', 'Lowstreet 4')

Q5.Retrive all record from mysql database using cursor.

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="myusername",
  password="mypassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

mycursor.execute("SELECT * FROM student")

myresult = mycursor.fetchall()

for x in myresult:
  print(x)

Output
('Peter', 'Lowstreet 4')
 ('Amy', 'Apple st 652')
 ('Hannah', 'Mountain 21')
 ('Michael', 'Canyon 123')
 ('Sandy', 'Ocean blvd 2')
 ('Betty', 'Green Grass 1')
 ('Richard', 'Sky st 331')
 ('Susan', 'One way 98')
 ('Vicky', 'Yellow Garden 2')
 ('Ben', 'Park Lane 38')