How do I get the “id” after INSERT into MySQL database with Python?

by

Use cursor.lastrowid to get the last row ID inserted on the cursor object, or connection.insert_id() to get the ID from the last insert on that connection.

More Related Contents:

  1. Bulk insert with SQLAlchemy ORM
  2. How to move a model between two Django apps (Django 1.7)
  3. What’s the difference between MySQLdb, mysqlclient and MySQL connector/Python?
  4. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  5. How can I connect to MySQL in Python 3 on Windows?
  6. Python & MySql: Unicode and Encoding
  7. Authentication plugin ‘caching_sha2_password’ is not supported
  8. How to disable SQLAlchemy caching?
  9. Setting Django up to use MySQL
  10. memory-efficient built-in SqlAlchemy iterator/generator?
  11. How can I insert data into a MySQL database?
  12. How to use MySQLdb with Python and Django in OSX 10.6?
  13. When to close cursors using MySQLdb
  14. How to enable MySQL client auto re-connect with MySQLdb?
  15. How to implement “autoincrement” on Google AppEngine
  16. Import psycopg2 Library not loaded: libssl.1.0.0.dylib
  17. Python MySql Insert not working
  18. Python: MySQLdb and “Library not loaded: libmysqlclient.16.dylib”
  19. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  20. trapping a MySql warning
  21. How to see the raw SQL queries Django is running?
  22. python logging to database
  23. Simple Subquery with OuterRef
  24. Django: Increment blog entry view count by one. Is this efficient?
  25. Reverse engineer SQLAlchemy declarative class definition from existing MySQL database?
  26. Python’s MySqlDB not getting updated row
  27. Django + MySQL on Mac OS 10.6.2 Snow Leopard
  28. Imploding a list for use in a Python MySQL IN clause
  29. Single Django model, multiple tables?
  30. How to disable query cache with mysql.connector

Leave a Comment