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
Ranking
Partitioning tables
MySQL, PHP character sets and collations
Queries
Special designs
Entity-attribute-value (EAV) model
Administering MySQL
Replication
phpMyAdmin
Setup
Reports
Configure MySQL & PHP in Windows
Security
Snippets
Backup & recovery
Stored routines
Utility
MySQL and Windows
Maintenance
Strings
MySQL and Visual Studio 2005
Memory use
Basic query methods
Triggers
Advanced
DataGridView
Versions
DataGridView: column search
MySQL 8.0
Data warehouses
DataSets
Just-in-time lookup grid
Date & Time
Setup MySQL test app
Documentation
TreeViews
8.0 Authentication
GUI Tools
Stored procedures and Connector.NET
OS-based MySQL GUIs
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
Access & connection issues
Upgrade from earlier version
Tablespaces
8.0 GIS
8.0 InnoDB
WorkBench
InnoDB architecture
Charset issues
Manage InnoDB file size
8.0 JSON
Transactions
8.0 New syntax
Common table expressions
Installation methods & issues
Java
Manipulating resultsets
8.0 Optimisation
Windows
MariaDB
8.0 Performance
Features of interest
8.0 Replication
MariaDB storage engines
WAMP
Group replication
8.0 Roles
Optimisation, performance
8.0 Shell
Migration
MySQL vs MariaDB
Views
Miscellaneous

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