Class 12th CBSE CS

Write a Code to Insert Data from Python to MYSQL.

Solution: –

import mysql.connector as cn
s = cn.connect(
    host = "localhost",
    user = "root",
    passwd = "root",
    database = "bank",
    auth_plugin="mysql_native_password")
mycursor = s.cursor()

sql = "INSERT INTO bank (name, address) VALUES (%s, %s)"
val = ("Hardik", "Althan")
mycursor.execute(sql, val)

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