Python Forum
Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
get last row id in pymysql
#1
Hello, I am pretty new to python
I am wondering is this is the correct syntax to get the last row id in a my=sql mysql table?
cur=conn.cursor()
sql="SELECT row_id FROM test_tb ORDER BY row_id DESC LIMIT 1"
cur.execute(sql)
last_id = cur.fetchone()
for lastID in last_id:
    print(lastID)
Thanks.
Reply
#2
You can do it with your query:
SELECT * FROM Table ORDER BY ID DESC LIMIT 1
you have it (almost)  right, so there will only be one row, and it's the one you want.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Mysql Syntax error in pymysql ilknurg 4 2,291 May-18-2022, 06:50 AM
Last Post: ibreeden
  pymysql can't do SELECT * Pedroski55 3 2,902 Sep-11-2021, 10:18 PM
Last Post: Pedroski55
  pymysql won't handle some diacritic characters awarren2001AD 0 1,237 Apr-16-2020, 08:58 AM
Last Post: awarren2001AD
  pyMySQL - ROW_NUMBER in SQL statement JayCee 1 2,339 Apr-12-2020, 08:40 PM
Last Post: JayCee
  pyMySQL How do I get the row id JayCee 3 2,667 Apr-12-2020, 08:38 PM
Last Post: JayCee
  PyMySQL return a single dictionary Valon1981 2 1,734 Feb-20-2020, 04:07 PM
Last Post: Valon1981
  pymysql: formating ouput of query wardancer84 18 8,182 Oct-04-2018, 01:54 PM
Last Post: wardancer84
  pymysql ifnull aland 4 3,939 Sep-06-2018, 05:58 AM
Last Post: buran
  pymysql question tony1812 1 2,862 Sep-26-2017, 12:41 AM
Last Post: Larz60+
  pymysql on macos seirra tony1812 5 4,497 Sep-17-2017, 03:24 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020