MySQL Articles, Tips & Snippets

See also our Common Queries page


Database design
Optimise subqueries
MySQL and web apps
Ranking
Database basics
MySQL and Java
Queries
Basics
Foreign Keys
MySQL and PHP
Setup
Replication
Generate random data
Configure MySQL & PHP in Windows
History, point-in-time architecture
Managing duplicates
Basics
Models & modelling
Group replication
Partitioning tables
InnoDB Cluster
Special designs
MySQL, PHP character sets and collations
Security
Entity-attribute-value (EAV) model
Administering MySQL
Stored routines
phpMyAdmin
Snippets
Strings
Utility
MySQL and Windows
Triggers
Backup & recovery
Versions
MySQL and Visual Studio 2005
MySQL 8.0
Basic query methods
Xtrabackup
Connections
DataGridView
Maintenance
DataGridView: column search
Memory use
DataSets
Just-in-time lookup grid
8.0 Aggregation
Server crashes
Setup MySQL test app
8.0 Charsets & collations
Manage users
Scaling
TreeViews
Upgrades
Stored procedures and Connector.NET
8.0 Database management
Windows
MySQL Comparisons
Advanced
MySQL errors
Data Dictionary
Migration & upgrade
MySQL installation & setup
Upgrade from earlier version
Building MySQL
Data warehouses
Tablespaces
Access & connection issues
8.0 GIS
Date & Time
8.0 InnoDB
GUI Tools
OS-based MySQL GUIs
WorkBench
Web-based MySQL GUIs
InnoDB
Charset issues
8.0 JSON
InnoDB config variables
8.0 Key and reserved words
8.0 New syntax
Common table expressions
Installation methods & issues
8.0 Optimisation
Windows
8.0 Performance
8.0 Replication
InnoDB architecture
On Mac OS
Manage InnoDB file size
WAMP
Group replication
Transactions
8.0 Security
OLAP, reports
Authentication
Reports
Java
Optimisation, performance
Roles
Manipulating resultsets
MariaDB
8.0 Shell
Features of interest
8.0.13 changes
8.0.14 changes
MariaDB storage engines
8.0.16 changes
DB design and performance
8.0.17 changes
InnoDB
8.0.18
Migration
Upgrade
Query optimisation
MySQL vs MariaDB
Views
Miscellaneous

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