MySQL does not let you loop in ad-hoc SQL. Here is how to write a loop in MySQL with a simple stored procedure that uses LOOP, ITERATE and LEAVE.
MYSQL – Identifying Current Version of MySQL Server Installation – Part 2
Readers shared more ways to find the current version of MySQL: SELECT VERSION(), SELECT @@Version, the STATUS command and SHOW VARIABLES.
MySQL – How to Find mysqld.exe with Command Prompt – Fix: ‘mysql’ is not recognized as an internal or external command, operable program or batch file
Getting ‘mysql’ is not recognized as an internal or external command? Here is how to find mysqld.exe with the command prompt and run it from the right folder.
Big Data – ClustrixDB – Extreme Scale SQL Database with Real-time Analytics, Releases Software Download – NewSQL
ClustrixDB is a mature NewSQL database with extreme scale and real-time analytics, and it now has a software download. Here is what I learned about it.
MYSQL – Detecting Current Version of MySQL Server Installation
How do you find the current version of MySQL Server installed on your machine? Run one simple SHOW VARIABLES command from the command prompt or MySQL Workbench.
SQLAuthority News – 7th Anniversary of Blog – A Personal Note
Seven years ago I started blogging to save my own DBA solutions. On the 7th anniversary of SQLAuthority, here is a personal note on how it all began.
SQLAuthority News – Learn MySQL Indexing in 99 Minutes – MySQL Indexing for Performance – Video Course
A good index speeds up a query and a bad one slows it down. My new video course teaches MySQL indexing for performance in just 99 minutes.