MySQL supports NATURAL JOIN, which maps matching columns from both tables on its own. I show how it works and the key difference from INNER JOIN.
MySQL – Reset Row Number for Each Group – Partition By Row Number
MySQL has no ROW_NUMBER() OVER (PARTITION BY), so here is how to reset row number for each group with a variable, using a simple example.
MySQL – Generating Row Number for Each Row Using Variable
MySQL has no ROW_NUMBER() function like SQL Server. Here are two methods for generating row number values for each row with a variable in a SELECT statement.
MySQL – How to Detect Current Time Zone Name in MySQL
Need the current time zone of the MySQL server you are connected to? One simple query with @@system_time_zone returns the time zone name.
MySQL – When to Use TIMESTAMP or DATETIME – Difference Between TIMESTAMP or DATETIME
Confused about TIMESTAMP or DATETIME in MySQL? I explain the two factors, starting with supported range, that help you decide which one to use.
Backing Up MySQL, Explained for SQL Server DBAs
Backing up MySQL means choosing logical or physical copies and retaining binary logs for point-in-time recovery, then testing restores.
MYSQL – Could not Drop Object [Content] (‘Cannot delete or update a parent row: a foreign key constraint fails’, 1217) DROP DATABASE DatabaseName
Cannot drop a MySQL table or database because a foreign key constraint fails with error 1217? Turn off FOREIGN_KEY_CHECKS, drop it, then turn checks back on.