Browsing Category
MySQL
65 posts
MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter My, and “SQL”, the acronym for Structured Query Language.
How to Use the LIKE Operator in MySQL Database
LIKE is probably the single most misused operator I encounter when reviewing other people’s SQL — not because…
How to Handle NULL Values in MySQL Database
I still remember the first time a NULL value quietly broke one of my reports. I had written…
How to Perform Subqueries in MySQL Database
I remember the exact moment subqueries clicked for me. I was trying to find every customer who had…
How to Use GROUP BY in MySQL Database
I didn’t really understand GROUP BY until I had to build my first sales dashboard. My manager asked…
How to Perform MySQL JOIN Operations
For a long time I treated JOINs as a syntax puzzle — memorize INNER, LEFT, RIGHT, and hope…
How to Secure a MySQL Database
A few years ago I inherited a production MySQL server that still had a root account accessible from…
How to Use Transactions in MySQL Database
I learned the importance of transactions the hard way — a payment script I wrote years ago deducted…
How to Create Triggers in MySQL Database
I started using triggers almost by accident. I needed to keep an audit_log table in sync with every…
How to Create Stored Procedures in MySQL Database
The first stored procedure I ever wrote was born out of frustration, not elegance. I had a five-step…
How to Export Data from MySQL to a CSV File
I export data out of MySQL more often than almost any other operation I perform as a working…