How to insert values into MySQL server table using Python? Last Updated : 23 Jul, 2025 Comments Improve Suggest changes 2 Likes Like Report See More Prerequisite: Python: MySQL Create Table In this article, we are going to see how to get the size of a table in MySQL using Python. Python allows the integration of a wide range of database servers with applications. A database interface is required to access a database from Python. MySQL Connector-Python module is an API in python for communicating with a MySQL database Approach: Set up a Database serving either locally or globally.Install Python Connector inorder to communicate with Databases.Establish Database Connection using a Connector.Need to have a Table to insert data, Create a Table if you don’t have any.Modify Data in Table [ CRUD operation ] using a cursor object returned by Connector.Close the Database connection If you are done with it. We are going to use this table: Example 1: Adding one row into a Table with static values : Syntax : "INSERT INTO table_name (column_name) VALUES ( valuesOfRow );" Below is the implementation: Python3 import mysql.connector db = mysql.connector.connect( host="localhost", user="root", passwd="root", database="testdb" ) # getting the cursor by cursor() method mycursor = db.cursor() insertQuery = "INSERT INTO Fruits (Fruit_name) VALUES ('Apple');" mycursor.execute(insertQuery) print("No of Record Inserted :", mycursor.rowcount) # we can use the id to refer to that row later. print("Inserted Id :", mycursor.lastrowid) # To ensure the Data Insertion, commit database. db.commit() # close the Connection db.close() Output: No of Record Inserted : 1 Inserted Id : 1 How our table looks in SQL after insertion: Example 2: Adding multiple rows into a table with static values : Syntax : ''INSERT INTO table_name (column_name) VALUES ( valuesOfRow1),(valuesOfRow2),....(valuesOfRowN);'' Below is the implementation: Python3 import mysql.connector db = mysql.connector.connect( host="localhost", user="root", passwd="root", database="testdb" ) #getting the cursor by cursor() method mycursor = db.cursor() insertQuery = '''INSERT INTO Fruits (Fruit_name, Taste, Production_in ) VALUES ('Banana','Sweet',210);''' mycursor.execute(insertQuery) print("No of Record Inserted :", mycursor.rowcount) # To ensure the data insertion, Always commit to the database. db.commit() # close the Connection db.close() Output: No of Record Inserted : 2 How our table looks in SQL after insertion: Create Quiz Comment D deepakdk Follow 2 Improve D deepakdk Follow 2 Improve Article Tags : Python Python-mySQL Explore Python FundamentalsPython Introduction 2 min read Input and Output in Python 4 min read Python Variables 4 min read Python Operators 4 min read Python Keywords 2 min read Python Data Types 8 min read Conditional Statements in Python 3 min read Loops in Python - For, While and Nested Loops 5 min read Python Functions 5 min read Recursion in Python 4 min read Python Lambda Functions 5 min read Python Data StructuresPython String 5 min read Python Lists 4 min read Python Tuples 4 min read Python Dictionary 3 min read Python Sets 6 min read Python Arrays 7 min read List Comprehension in Python 4 min read Advanced PythonPython OOP Concepts 11 min read Python Exception Handling 5 min read File Handling in Python 4 min read Python Database Tutorial 4 min read Python MongoDB Tutorial 3 min read Python MySQL 9 min read Python Packages 10 min read Python Modules 3 min read Python DSA Libraries 15 min read List of Python GUI Library and Packages 3 min read Data Science with PythonNumPy Tutorial - Python Library 3 min read Pandas Tutorial 4 min read Matplotlib Tutorial 5 min read Python Seaborn Tutorial 3 min read StatsModel Library - Tutorial 3 min read Learning Model Building in Scikit-learn 6 min read TensorFlow Tutorial 2 min read PyTorch Tutorial 6 min read Web Development with PythonFlask Tutorial 8 min read Django Tutorial | Learn Django Framework 7 min read Django ORM - Inserting, Updating & Deleting Data 4 min read Templating With Jinja2 in Flask 6 min read Django Templates 5 min read Build a REST API using Flask - Python 3 min read Building a Simple API with Django REST Framework 3 min read Python PracticePython Quiz 1 min read Python Coding Practice 1 min read Python Interview Questions and Answers 15+ min read Like