Databases
- Finding slow MySQL queries
- Notes on SQL
- Notes on Moving from MySQL to MariaDB and Replication
- Find out MySQL Database sizes
- Notes on Moving Large Databases
- Allowing remote access to MySQL
- Search for characters in SQL with LIKE and CONTAIN
- Conditional Statements in SQL with CASE
- Referencing data from multiple tables using JOINs
- Intermediate SQL
- SQL basics
- Connect to MySQL installed by MAMP via Command Line (Terminal)
- Secure MySQL installation non-interactively with a bash script
- Update WordPress posts for SSL https
- Common MySQL Errors
- Reset MySQL root password on Linux
- OpenCart: Bulk Update Customer Group via phpmyadmin
- Install MongoDB on MacOS
- Getting started with Firebase Hosting
- SQLite Basics
- OpenCart: Delete Multi-Store and Move Everything to the Default Store
- Joining Relational Data between Tables in SQL
- Manipulating Schema with SQL
- Using PHP with MySQL
- Backing up and Restoring Databases
- Database Foundations
- Tips for Querying a MySQL Database
- OpenCart: Bulk update prices of Products
- How to add a WordPress Admin user via PhpMyAdmin
- Delete ALL Unapproved comments in WordPress
- Automated MySQL Backups to Amazon S3 with AutoMySQLBackups
- Making a MySQL database connection with PHP
- MongoDB Basics