MySQL and MariaDB build internal temporary tables behind your back for GROUP BY, DISTINCT, UNION and derived tables. This post counts them with status counters, reads them in EXPLAIN, shows what pushes one to disk, and removes one with an index.
Retrieve TOP 10 Rows Without Using TOP or LIMIT? – Interview Question of the Week #247
Question: Retrieve TOP 10 Rows Without Using TOP or LIMIT? We do not want to use TOP or LIMIT as they are actually not an ANSI implementation.
MariaDB – MySQL – Show Engines to Display All Available and Supported Engine
I inspect each Supported Engine with SHOW ENGINES on MariaDB. A customer using MariaDB alongside SQL Server asked about this list.
MySQL OUT Parameter: IN, OUT and INOUT in Stored Procedures
A MySQL OUT parameter lets a stored procedure hand a value back to the caller through a variable. This post tests IN, OUT and INOUT on a small table, shows the error you get when you pass a literal, and compares the syntax with SQL Server.
Connect to MySQL From the Command Prompt: Host, Port, User
To connect to MySQL from the command prompt, you pass a host, a port, a user and a password to the mysql client. This post runs every switch, then shows the exact error that a wrong port, user, password or database produces.
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.