Inserting data in Python

Inserting data in Python

Inserting data into a table to store it. Use INSERT INTO table_name (column_names) VALUES (data) statement to insert into the table.

Inserting A Single Row
you can read how to insert a single row into the table.

import mysql.connector as mysql

db = mysql.connect(
    passwd="[email protected]",

cursor = db.cursor()

query = "INSERT INTO user (name, user_name) VALUES (%s, %s)"
## storing values in a variable
values = ("Real Programmer", "RealProgrammer18")

## executing the query with values
cursor.execute(query, values)


print(cursor.rowcount, "Data Saved")
Leave a Comment