Insert into MySQL Table using Python

Introduction to Python

Collection in Python

Object Oriented python

Python With MYSQL And Excel

Python GUI

Programs in Python

Python with database

How to insert data in mysql table using python:

Using python we can insert the data into mysql table . For doing this we must have created the database as previous chapter and then we need to create a table in which we are going to insert the data using python

1 For creating the table following sql query may be used.

use sharp_tutorial
create table student (sname varchar(20),course varchar(20) address varchar(20))

Insert the data into MySql table using Python

All previous steps are to be done as install mysql connector , create database and table

then by using following code we can insert the data into mysql table

import mysql.connector
db=mysql.connector.connect(
host="localhost",
user="root",
password="root",
database="sharp_tutorial")
print("succecssfully connected with database")
MyCursor=db.cursor()
sql="insert into student (sname,course,address) values (%s,%s,%s)"
sname=input("enter the name")
course=input("enter the course")
address=input("enter the address")
val=(sname,course,address)
MyCursor.execute(sql,val)
db.commit()
print("record inserted ")

Output: Record Inserted

If you check the table in database a record with the given data is being inserted there

Python

Java

C

C++

HTML/CSS

Java Script

PHP

SQL

C Programs

Python with database

How to insert data in mysql table using python:

Video/ C Introduction