mysql-play

My MySQL playground (sample schemas, examples of new features, experimental queries, test cases, utility routines, fun, etc.)

Contents

• DataMask - data masking routines.
• Debug - examples for tracing stored routines.
• Examples:
  • Admin - examples related to administration;
  • CHECK - examples with CHECK constraints;
  • GROUPING - examples with GROUPING function;
  • Index - examples with indexes (e.g. functional);
  • JSON - examples with JSON data and functions;
  • Join - examples with joins (e.g. lateral, hash, etc.);
  • Math - examples related to mathematics;
  • Optimizer - examples related to optimization (e.g. histogram, EXPLAIN, etc.);
  • PSM - examples with Persistent Stored Modules (i.e. stored routines);
  • Performance - examples related to performance;
  • SELECT - examples with SELECT statements;
  • Schema - sample schemas and operations on schemas;
  • Sets - examples with SQL set operators;
  • Spatial - examples with spatial data and functions;
  • TABLE - examples with CREATE TABLE and TABLE statements;
  • VALUES - examples with VALUES statement;
  • WITH - examples with CTEs;
  • Window - examples with window functions.
• Fun - fun scripts :-)
• Misc - miscellaneous scripts