Browsing Tag
mysql
64 posts
How to Use the UNION Operator in MySQL Database
I remember the exact moment UNION clicked for me — I was combining “active customers” and “recently churned…
How to Create and Manage MySQL Database Triggers
The first trigger I ever wrote in production was an audit log — every time a row in…
How to Use MySQL Database Events
When I first started managing production MySQL databases, I kept running into the same problem: I needed certain…
How to Perform Full-Text Search in MySQL Database
I remember the first time a client asked me to add a “search” box to their product catalog.…
How to Use the JSON Data Type in MySQL Database
I still remember debating with a teammate years ago about whether we should store a flexible “attributes” field…
How to Handle Time Zones in MySQL Database
I’ve been bitten by time zone bugs more than once — a “midnight” event that showed up as…
How to Create and Manage MySQL Database Views
Early in my career, I inherited a reporting dashboard built on top of a gnarly seven-table join that…
How to Use MySQL Database Command-Line Client
Before I ever touched a GUI database tool, I learned MySQL entirely through its command-line client, and honestly,…
How to Set up MySQL Database Workbench
For a long time I did everything in the terminal, and I was genuinely resistant to using a…
How to Use MySQL Database with Ruby on Rails
When I built my first production Rails application, I defaulted to SQLite because that’s what the generators set…