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.
- We need to install MySQL version 8.0.12.
- We need to install Python version 3.6.3 (32 bit).
- We need to install pymysql with the help of pip command.
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::
Published on 23-Nov-2018 12:32:34
