MySQL Shell get_auto_increment_value() method — Python mode

These days, I mostly program in PHP with MySQL as the database, which is just fine by me. I have had a long-time interest in MySQL (SQL in general), and after several steady months of programming in PHP, I must say I have really come into the language and developed a fondness for it. All that being said, I still enjoy using and learning the MySQL Shell in Python mode. As Database Developers, we often need the LAST INSERT ID value from a previous INSERT statement on a column that has the AUTO_INCREMENT attribute. MySQL Shell has a…

--

--

--

No Matter What People Tell You, Words And Ideas Can Change The World.

Recommended from Medium

“If it turns out that this is incurable, would you marry me?”

Setting up development tools in a docker container

INSERT with SELECT statement for columns with FOREIGN KEY constraint in MySQL with examples.

What happens when you type GCC main.c

Contract-based testing 3: Accept, or get out

Developer staring out the window

Dune-Top 50 Traders

Study Guide for Microsoft Azure Data Scientist Associate Certification Exam (DP-100 — Designing…

Taking advantage of BIM clash detection for seamless architecture and construction

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Joshua Otwell

Joshua Otwell

SQL and PHP/CodeIgniter Developer. Growing through Technical Writing and Blogging. Sign-up for my free newsletter here: openlamptech.substack.com

More from Medium

Changing POSIX code to Python

Python queries to work with multiple instances of Oracle and SQL Server.

Create and publish your package into PyPI

CRUNCH COUNTER IN PYTHON