How to return the last primary key after INSERT in pymysql (python3.5)?

Question

CREATE TABLE `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `email` varchar(255) COLLATE utf8_bin NOT NULL,
    `password` varchar(255) COLLATE utf8_bin NOT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
AUTO_INCREMENT=1 ;

for example, how to get the primary key id of the last record that I insert into the table by cursor.execute("insert into ...", ...)?

http://stackoverflow.com/questions/2548493/how-do-i-get-the-id-after-insert-into-mysql-database-with-python Perhaps this is what you are looking for — greperror, May 30 '16 at 11:32
Possible duplicate of [How do I get the "id" after INSERT into MySQL database with Python?](https://stackoverflow.com/questions/2548493/how-do-i-get-the-id-after-insert-into-mysql-database-with-python) — sergiomafra, May 06 '19 at 20:28

shivsn · Answer 1 · 2016-05-31T06:55:00.817

7

after inserting,You can get it as: cursor.execute('select LAST_INSERT_ID()') or use cursor.lastrowid

edited May 31 '16 at 06:55

answered May 30 '16 at 11:30

shivsn

7,680
1
26
33

1

ids = cursor.execute('select LAST_INSERT_ID()') print(ids) it just got `1`, not the last insert id! – xaero May 30 '16 at 13:25
2

try `cursor.lastrowid` . – shivsn May 30 '16 at 13:40

How to return the last primary key after INSERT in pymysql (python3.5)?

1 Answers1

Linked