MySQL Articles, Tips & Snippets

See also our Common Queries page


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

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