How do I get the id after INSERT into MySQL database in Python?

First, we need to complete the below requirements. The following are the prerequisites.

To install “pymysql” with the help of pip command.

The database name is ‘business’ and the table name is ‘student’ with ID 3 after inserting records.

Here is the query.

mysql> select *from student;

The following is the output.

+------+-------+
| id   | Name  |
+------+-------+
|    1 | John  |
|    2 | Bob   |
|    3 | Smith |
+------+-------+
3 rows in set (0.00 sec)

We can get it with the help of Python for the same table name and database business.

The Python code snapshot is as follows −

The following is the output.

The output for MySQL and Python gets the ID after inserting::

Updated on 30-Jul-2019 22:30:23