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 Import Data into MySQL from a CSV File
I once imported a 2-million-row CSV into MySQL using individual INSERT statements generated by a script, and watched…
How to Restore a MySQL Database Backup
The worst phone call any DBA can get is “production is down and we need last night’s backup…
How to Backup a MySQL Database
I’ve never regretted having an extra backup, but I’ve absolutely regretted not having one. Early in my career,…
How to Optimize MySQL Database Queries
Query optimization is the skill I’ve spent the most years refining, and honestly, I don’t think I’ll ever…
How to Create Indexes in MySQL Database
If there’s one topic that separates people who can write SQL from people who can actually run a…
How to Set up MySQL Replication
Replication is the point where I feel like I graduated from “person who runs a database” to “person…
How to Connect to a Remote MySQL Server
Connecting to a remote MySQL server sounds trivial until the moment it doesn’t work, and then I’m suddenly…
How to Delete Data from a MySQL Table
Deleting data is the operation I approach most carefully out of everything MySQL lets me do, because it’s…
How to Update Data in a MySQL Table
Of all the DML statements I write, UPDATE is the one I treat with the most respect, because…
How to Query Data from a MySQL Database
If installing MySQL is the foundation, then querying data is the room I actually spend most of my…