MySQL Articles, Tips & Snippets

See also our Common Queries page


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

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