MySQL Articles, Tips & Snippets

See also our Common Queries page


Database design
DB design and performance
MySQL and web apps
InnoDB
MySQL and Java
Database basics
Query optimisation
Basics
MySQL and PHP
Basics
History, point-in-time architecture
Managing duplicates
Partitioning tables
Optimise subqueries
MySQL, PHP character sets and collations
Special designs
Ranking
Entity-attribute-value (EAV) model
Queries
Administering MySQL
phpMyAdmin
Replication
Setup
Configure MySQL & PHP in Windows
Reports
Backup & recovery
Snippets
Security
Utility
MySQL and Windows
Stored routines
Maintenance
MySQL and Visual Studio 2005
Advanced
Basic query methods
Strings
Triggers
Data warehouses
DataGridView
DataGridView: column search
Versions
DataSets
MySQL 8.0
Date & Time
Just-in-time lookup grid
Documentation
Setup MySQL test app
GUI Tools
OS-based MySQL GUIs
TreeViews
MySQL Query Browser
Stored procedures and Connector.NET
Web-based MySQL GUIs
MySQL Comparisons
8.0 Charsets & collations
InnoDB
InnoDB config variables
MySQL errors
8.0 Database management
MySQL installation & setup
Data Dictionary
Migration & upgrade
Access & connection issues
Upgrade from earlier version
8.0 GIS
8.0 InnoDB
WorkBench
InnoDB architecture
Transactions
Charset issues
8.0 JSON
8.0 New syntax
Common table expressions
Java
Installation methods & issues
Manipulating resultsets
8.0 Optimisation
MariaDB
Windows
8.0 Performance
Features of interest
8.0 Replication
MariaDB storage engines
Group replication
8.0 Roles
WAMP
Optimisation, performance
8.0 Slideshow: What's new?
Migration
MySQL vs MariaDB
Views
Miscellaneous

Contribute an item or correction ** New or updated Tree view Get It Done With MySQL 5&Up