Saturday, August 30, 2025
HomeLanguagesGet the id after INSERT into MySQL database using Python

Get the id after INSERT into MySQL database using Python

 Prerequisites: MySQL, mysql-connector for python

The task here is to draft a Python program that works with SQL support to connect data. Whenever insertion into the database takes place, the ID of the row inserted will be printed. To connect python with the database we are using MySQL connector. 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 MySQL Server. 

INSERT Clause in SQL

As the name suggests, it inserts data into the database. Certain rules need to be followed while using the insert command. The data to be updated should either be in the same order as the columns of the database or names of the columns should be given to the query along with the data to be inserted.

Syntax:

INSERT INTO <tablename>(Col1,Col2, …)

VALUES(….);

To print the ID of the last inserted row lastrowid will be used. This is a special keyword that prints the ID of the row last inserted but to do so there are certain protocols that had to be kept in mind before employing this:

  • ID column of the database should be a primary key
  • ID column should auto-incremented.

Given below is the implementation of the same:

Database In Use:

Below is the implementation:

Python3




import mysql.connector
  
mydb = mysql.connector.connect(
    host = 'localhost',
    database = 'employee',
    user = 'root',
    password = 'Your_pass'
)
  
cs = mydb.cursor()
statement = "INSERT INTO Lazyroartudent( id, name,gender, subject)\
VALUES(6,'Shoit','M', 'ML')"
cs.execute(statement)
mydb.commit()
  
print(cs.rowcount, " record(s) added")
  
print(cs.lastrowid)


Output:

1  record(s) added
0

Updated Database Output:

RELATED ARTICLES

Most Popular

Dominic
32250 POSTS0 COMMENTS
Milvus
81 POSTS0 COMMENTS
Nango Kala
6617 POSTS0 COMMENTS
Nicole Veronica
11792 POSTS0 COMMENTS
Nokonwaba Nkukhwana
11840 POSTS0 COMMENTS
Shaida Kate Naidoo
6733 POSTS0 COMMENTS
Ted Musemwa
7014 POSTS0 COMMENTS
Thapelo Manthata
6689 POSTS0 COMMENTS
Umr Jansen
6704 POSTS0 COMMENTS