MySQL Articles, Tips & Snippets

See also our Common Queries page


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