New MySQL users often ask where to find my.ini or my.cnf on Windows. I show a quick way to see which file is powering your MySQL Server configuration.
MySQL – MySQL Query Optimization and Performance Tuning – Online Video Courses
My second MySQL performance course is out: MySQL Query Optimization and Performance Tuning, after MySQL Indexing for Performance. Here is what it covers.
SQL SERVER – MySQL – LIMIT and OFFSET – Skip and Return Only Next Few Rows – Paging Solution
Paging in MySQL and SQL Server: use LIMIT and OFFSET to skip some rows and return only the next few, with examples for both databases.
SQL SERVER – MySQL – PostgreSQL – How to Concat Strings?
How to concat strings the same way in SQL Server, MySQL and PostgreSQL? I switched from the plus operator to the CONCAT function, and here is why.
MySQL – How to Change Delimiter in MySQL – Supporting GO Keyword of SQL Server in MySQL
Copied a SQL Server script with GO into MySQL and got an error? Here is how to change delimiter in MySQL so it accepts GO as a statement terminator.
MySQL – How to Create Stored Procedure
Confused by semicolons when you create stored procedure code in MySQL? Change the DELIMITER first, then reset it. Here is a simple example.
SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer
How do you order column values by how close they are to any integer, such as -5? Here is a script that works the same way on SQL Server and MySQL.