Exploring .count() and COUNT() — MySQL Shell Python mode

Retrieving a table count of rows using the COUNT(*) aggregate function in MySQL is a straight-forward query. What if I told you that with the MySQL Shell, there are actually 3 possible ways – between 2 Shell modes (\sql and \py) – to retrieve a table row count? Would you be interested in knowing about them? Honestly, one of the queries will not surprise you in the least bit, as you are likely already using it. However, the other 2 queries – in this context – are specific to MySQL Shell Python mode. You can likely execute these queries in Javascript Mode…

--

--

--

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

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Towards a Kubernetes native Future

Kiwicode startup story(9): Customers need to build complex apps, not simple ones.

Best extensions for JupyterLab!!

Identifying Outliers

Decorators in Python

Ruby vs Javascript in Several Images

CS 371g Summer 2020: Steve Han

Night Owl’s Weekly Update [30/03/2022]

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

Performing Analysis of Meteorological Data

How to do Karate setup?

Detail Solution Explanation On SQL Murder Mystery Question

Oracle Database Analysis and Manipulation Through Python