MySQL SELECT and WHERE Clause Column Existence

I’m sharing another tip for anyone who wants to learn more about MySQL and how to use it. This post covers an example of the differences in columns specified in the WHERE clause but not the SELECT clause and vice-versa. Image by Drizzt_Do_Urden from Pixabay  The Newsletter for PHP and MySQL Developers Receive a copy of my ebook, […]

Continue Reading

Announcing Vitess 14

We are pleased to announce the general availability of Vitess 14. Major Themes # In this new release, major improvements have been made in several areas of Vitess, including usability and reliability. Online DDL is now GA. Gen4 planner is the new default planner. VTAdmin and VTOrc are officially in beta with Vitess 14. Usability […]

Continue Reading

OpenLampTech issue #32 – Substack Repost

There is a whole lot of great PHP, MySQL, and LAMP-stack content in this week’s OpenLampTech newsletter. But, would you expect any less? Me neither. Enjoy this edition and share with others. Thank you for being a dedicated reader! The Newsletter for PHP and MySQL Developers Receive a copy of my ebook, “10 MySQL Tips […]

Continue Reading

MySQL Query from JSON

One of my students asked how you could get JSON data out in tabular format. I said they should look at Øystein Grøvlen’s JSON_TABLE – Best of Both Worlds blog post from 2018. Unfortunately, the wanted another example with the Video Store model that we use in class. So, here’s a quick supplement to what’s […]

Continue Reading

MySQL Backslashes

Yesterday, I wrote a blog post that showed you how to write a query returning a JSON structure for a 1:many relationship. The relationship was between the member and contact table. It returns one account_number from the member table and a list of first_name and last_name columns from the contact table in a JSON structure. […]

Continue Reading

MySQL JSON Tricks

Are they really tricks or simply basic techniques combined to create a solution. Before writing these mechanics for using native MySQL to create a compound JSON object, let me point out that the easiest way to get one is to use the MySQL Node.js library, as shown recently in my “Is SQL Programming” blog post. […]

Continue Reading

JDBC Request: Cannot load JDBC driver class’com.mysql.jdbc.Driver’ solution

  Just  quick post to document an troublesome error when running Jmeter on Mysql JDBC Request: Cannot load JDBC driver class’com.mysql.jdbc.Driver’ solution Should be pretty simple, it’s just a question of putting the mysql-connector-java jar file, available at https://dev.mysql.com/downloads/connector/j/, into the classpath for Jmeter. The easiest way for me is to put this into the jmx file: […]

Continue Reading

Find All Table’s Current AUTO_INCREMENT Value

I recently wanted to check all tables’ current AUTO_INCREMENT value (if any) for a database dump structure. I wasn’t sure if a tables’ Data Definition Language (DDL) statement contained the current AUTO_INCREMENT value or not. So after I loaded the dump file, I learned of a query to use and find out… The Newsletter for […]

Continue Reading