MySQL Articles, Tips & Snippets

See also our Common Queries page


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