Question

Write a python program on windows which can add data to a my sql database

Answer 1

First of all, my sql should be installed on your computer.

Code to add data to a my sql database:

import mysql.connector # Library to import

mydb = mysql.connector.connect(
host="localhost",
  user="yourusername",
passwd="yourpassword",
database="mydatabase"
) # mydb variable which will be used in the program

mycursor = mydb.cursor() # cursor

sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"  
val = ("John", "Highway 21")
mycursor.execute(sql, val) # execute command is that whcih executes your sql queries

mydb.commit() # Commit changes on your database

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