Skip to content

Courses
Tutorials
Practice
Contests

Python Database
Python MySQL
Python SQLite
Python MongoDB
PostgreSQL
SQLAlchemy
Django
Flask
SQL
ReactJS
Vue.js
AngularJS
API
REST API
Express.js
NodeJS

How to Show All Tables in MySQL using Python?

How to insert values into MySQL server table using Python?

Last Updated : 03 Jan, 2021

Comments

Improve

Suggest changes

Like Article

Like

Report

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:

How to Show All Tables in MySQL using Python?

deepakdk

Improve

Article Tags :

Python
Python-mySQL

Practice Tags :

python

Similar Reads

How to Concatenate Column Values of a MySQL Table Using Python?

Prerequisite: Python: MySQL Create Table In this article, we show how to concatenate column values of a MySQL table using Python. We use various data types in SQL Server to define data in a particular column appropriately. We might have requirements to concatenate data from multiple columns into a s

How to Show All Tables in MySQL using Python?

A connector is employed when we have to use mysql with other programming languages. The work of mysql-connector is to provide access to MySQL Driver to the required language. Thus, it generates a connection between the programming language and the MySQL Server. In order to make python interact with

Python MariaDB - Insert into Table using PyMySQL

MariaDB is an open source Database Management System and its predecessor to MySQL. The pymysql client can be used to interact with MariaDB similar to that of MySQL using Python. In this article we will look into the process of inserting rows to a table of the database using pymysql. You can insert o

Python MySQL - Insert into Table

MySQL is a Relational Database Management System (RDBMS) whereas the structured Query Language (SQL) is the language used for handling the RDBMS using commands i.e Creating, Inserting, Updating and Deleting the data from the databases. SQL commands are case insensitive i.e CREATE and create signify

Inserting variables to database table using Python

In this article, we will see how one can insert the user data using variables. Here, we are using the sqlite module to work on a database but before that, we need to import that package. import sqlite3 To see the operation on a database level just download the SQLite browser database.Note: For the d

How to Copy a Table in MySQL Using Python?

In this article, we will create a table in MySQL and will create a copy of that table using Python. We will copy the entire table, including all the columns and the definition of the columns, as well as all rows of data in the table. To connect to MySQL database using python, we need PyMySql module.

How to Find Duplicate Values in a SQL Table using Python?

MySQL server is an open-source relational database management system that is a major support for web-based applications. Databases and related tables are the main component of many websites and applications as the data is stored and exchanged over the web. In order to access MySQL databases from a w

How to list tables using SQLite3 in Python ?

In this article, we will discuss how to list all the tables in the SQLite database using Python. Here, we will use the already created database table from SQLite. We will also learn exception handling during connecting to our database. Database Used: Steps to Fetch all tables using SQLite3 in Python

How to Copy a Table Definition in MySQL Using Python?

Python requires an interface to access a database server. Python supports a wide range of interfaces to interact with various databases. To communicate with a MySQL database, MySQL Connector Python module, an API written purely in Python, is used. This module is self-sufficient meaning that it does

Using Sqlalchemy to insert MySQL Timestamp Column Values

This article is about how we can add a timestamp column with values in MYSQL along with other data in an SQL database. Timestamp is quite useful as it provides the time when that particular entity was created in the database. Here we will use SQLAlchemy as it is a popular Python programming SQL tool

Corporate & Communications Address:

A-143, 7th Floor, Sovereign Corporate Tower, Sector- 136, Noida, Uttar Pradesh (201305)

Registered Address:

K 061, Tower K, Gulshan Vivante Apartment, Sector 137, Noida, Gautam Buddh Nagar, Uttar Pradesh, 201305

Advertise with us

Company
About Us
Legal
Privacy Policy
In Media
Contact Us
Advertise with us
GFG Corporate Solution
Placement Training Program

Languages
Python
Java
C++
PHP
GoLang
SQL
R Language
Android Tutorial
Tutorials Archive

DSA
Data Structures
Algorithms
DSA for Beginners
Basic DSA Problems
DSA Roadmap
Top 100 DSA Interview Problems
DSA Roadmap by Sandeep Jain
All Cheat Sheets

Data Science & ML
Data Science With Python
Data Science For Beginner
Machine Learning
ML Maths
Data Visualisation
Pandas
NumPy
NLP
Deep Learning

Web Technologies
HTML
CSS
JavaScript
TypeScript
ReactJS
NextJS
Bootstrap
Web Design

Python Tutorial
Python Programming Examples
Python Projects
Python Tkinter
Python Web Scraping
OpenCV Tutorial
Python Interview Question
Django

Computer Science
Operating Systems
Computer Network
Database Management System
Software Engineering
Digital Logic Design
Engineering Maths
Software Development
Software Testing

DevOps
Git
Linux
AWS
Docker
Kubernetes
Azure
GCP
DevOps Roadmap

System Design
High Level Design
Low Level Design
UML Diagrams
Interview Guide
Design Patterns
OOAD
System Design Bootcamp
Interview Questions

Inteview Preparation
Competitive Programming
Top DS or Algo for CP
Company-Wise Recruitment Process
Company-Wise Preparation
Aptitude Preparation
Puzzles

School Subjects
Mathematics
Physics
Chemistry
Biology
Social Science
English Grammar
Commerce
World GK

GeeksforGeeks Videos
DSA
Python
Java
C++
Web Development
Data Science
CS Subjects

@GeeksforGeeks, Sanchhaya Education Private Limited, All rights reserved

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy

Improvement

Suggest Changes

Help us improve. Share your suggestions to enhance the article. Contribute your expertise and make a difference in the GeeksforGeeks portal.

geeksforgeeks-suggest-icon

Create Improvement

Enhance the article with your expertise. Contribute to the GeeksforGeeks community and help create better learning resources for all.

geeksforgeeks-improvement-icon

Suggest Changes

min 4 words, max Words Limit:1000

Thank You!

Your suggestions are valuable to us.

What kind of Experience do you want to share?

Interview Experiences

Admission Experiences

Career Journeys

Work Experiences

Campus Experiences

Competitive Exam Experiences