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.
Find mysqld.exe on Windows and Fix ‘mysql’ Is Not Recognized
To find mysqld.exe on Windows, search the drive with dir or where, or ask the running server where it lives. This post fixes the ‘mysql’ is not recognized error by adding the bin folder to PATH, and it shows every command with its real output.
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.
Migrating From MySQL to SQL Server: AUTO_INCREMENT, LIMIT and Other Differences
Plan migrating from MySQL with clear translations for identity values, paging, dates, booleans, string functions, and upserts.
Mapping MySQL Data Types to SQL Server
Mapping MySQL data types requires checking signed ranges, text encoding, date limits, and application behavior before choosing SQL Server columns.