MySQL Articles, Tips & Snippets

See also our Common Queries page


Database design
DB design and performance
InnoDB
MySQL and web apps
MySQL and Java
Query optimisation
Database basics
Basics
MySQL and PHP
Basics
History, point-in-time architecture
Managing duplicates
Optimise subqueries
Partitioning tables
MySQL, PHP character sets and collations
Special designs
Ranking
Queries
Entity-attribute-value (EAV) model
Administering MySQL
phpMyAdmin
Replication
Setup
Configure MySQL & PHP in Windows
Reports
Security
Backup & recovery
Snippets
Utility
Stored routines
MySQL and Windows
Maintenance
MySQL and Visual Studio 2005
Advanced
Strings
Basic query methods
Triggers
Data warehouses
DataGridView
DataGridView: column search
Versions
MySQL 8.0
DataSets
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
8.0 Authentication
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
Manage InnoDB file size
Charset issues
8.0 JSON
Transactions
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
Group replication
MariaDB storage engines
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