SQLiz

Learn SQL and Databases with Practical Examples

SQLiz is a practical learning library for SQL and databases. Browse query examples for MySQL, PostgreSQL, SQLite, MariaDB, and SQL Server, alongside references and setup guides for Oracle, MongoDB, Redis, and more. Use the SQL and database tools or run SQLite queries in a temporary browser database, search for a function or diagnose a common MySQL or PostgreSQL error, choose a database tutorial below, or browse all articles for installation and programming guides.

MySQL Tutorial PostgreSQL Tutorial MariaDB Tutorial MySQL Reference PostgreSQL Reference SQLite Function Reference MariaDB Reference MongoDB Reference Tools Oracle Reference SQL Server Reference Sakila Tutorial

How to Size a MySQL Connection Pool

Calculate a safe MySQL pool ceiling across app replicas, then tune it with database and application metrics instead of guessing.

Enable the MySQL 26.7 Thread Pool on Debian 13

Enable and verify MySQL 26.7 Community Thread Pool on Debian 13, then inspect its Performance Schema tables and tune only after testing.

MySQL Error 2015: Named Pipe Connection on Windows

Troubleshoot MySQL Error 2015 on Windows by checking named-pipe support, the pipe name, and client access permissions.

Upgrade MySQL 9.7 LTS to 26.7 Innovation on Debian 13

Plan a Debian 13 upgrade from MySQL 9.7 LTS to 26.7 Innovation with Oracle’s APT repository, a verified backup, and package checks.

How to Install MySQL 26.7 Innovation on Debian 13

Install MySQL 26.7 Innovation on Debian 13 using Oracle’s APT repository, select the mysql-innovation series, and verify the server package.

How to Upgrade PostgreSQL 14 to PostgreSQL 18

PostgreSQL 14 support ends Nov 12, 2026. Plan an upgrade to 18 with pg_upgrade checks, checksum compatibility, a tested backup, and application validation.

How to Upgrade PostgreSQL 17 to PostgreSQL 18

Plan a PostgreSQL 17 to 18 major-version upgrade with pg_upgrade: check extensions and checksums, test backups, use check mode, and verify the new cluster.

How to Upgrade MySQL 8.0 to MySQL 8.4 LTS

Plan a safe MySQL 8.0 to 8.4 LTS upgrade: verify platform support, run MySQL Shell Upgrade Checker, rehearse on a clone, and validate backups.

How to Upgrade MySQL 8.4 to MySQL 9.7 LTS

Plan a MySQL 8.4 to 9.7 LTS upgrade: confirm the supported path, run MySQL Shell Upgrade Checker, rehearse a restorable backup, and use the right package workflow.

MySQL Error 1524: Plugin 'mysql_native_password' Is Not Loaded

Fix MySQL Error 1524 on MySQL 8.4 by switching accounts to caching_sha2_password, or temporarily enable the deprecated plugin while migrating.

MySQL Error 2059: Authentication Plugin Cannot Be Loaded

Troubleshoot client-side MySQL Error 2059 by checking connector support, loaded client libraries, plugin directories, and authentication compatibility.

How to Install MySQL 9.7 LTS on Ubuntu 22.04

Install MySQL 9.7 LTS on Ubuntu 22.04 from Oracle’s APT repository, verify the Jammy candidate, and create a database-scoped application account.

How to Install MySQL 9.7 LTS on Ubuntu 24.04

Install MySQL 9.7 LTS on Ubuntu 24.04 with Oracle’s APT repository, verify the selected package, and create a database-scoped application account.

SQLite jsonb() Function

Convert JSON text to SQLite’s binary JSONB BLOB with jsonb(), or pass through an input that appears to be JSONB.

SQLite jsonb_each() Function

Use SQLite jsonb_each() to expand one JSON object or array level, returning nested objects and arrays as JSONB values.

SQLite jsonb_tree() Function

Use SQLite jsonb_tree() to recursively expand JSON, returning nested objects and arrays as JSONB values.

SQLite JSONB: When and How to Use It

Learn how SQLite JSONB stores JSON in an internal BLOB, how to convert between JSON text and JSONB, and what performance and compatibility limits matter.

SQLite timediff() Function

Learn how SQLite timediff() returns a calendar-aware modifier and when to use julianday() or unixepoch() for exact elapsed time.

MySQL Error 1114: The Table Is Full

Diagnose MySQL Error 1114 by checking disk space, the affected storage engine, InnoDB tablespaces, MEMORY limits, and query temporary tables.

PostgreSQL Error 22007: Invalid Datetime Format

Fix PostgreSQL SQLSTATE 22007 by checking DateStyle, using ISO date values, and parsing fixed input formats explicitly.

How to Install MySQL 9.7 on macOS with Homebrew

Install MySQL 9.7 LTS with Homebrew on Apple Silicon, run it as a local service, secure the root account, and create a restricted application user.

How to Install MySQL 9.7 on Windows

Install MySQL 9.7 LTS on supported Windows systems using the MSI and MySQL Configurator, keep network access local, and create a restricted application account.

Install MariaDB Server on Windows with the MSI Installer

Install MariaDB on 64-bit Windows using the official MSI, configure a local service and root password, then create a restricted application account.

MySQL Error 1142: Command Denied for Table

Fix MySQL Error 1142 by identifying the authenticated account, checking active roles, and granting only the required table privilege.

MySQL Error 1143: Column Access Denied

Troubleshoot MySQL Error 1143 by checking the matched account, active roles, and column-level grants for the denied operation.

About SQLiz.com

SQLiz.com is a database learning and reference site with tutorials, installation guides, practical examples, and database documentation.

2 Ways to List Stored Procedures in MySQL

List MySQL stored procedures with SHOW PROCEDURE STATUS or INFORMATION_SCHEMA.ROUTINES, filter by database, and understand privilege limits.

3 Ways to Find a Substring's Position in MySQL

Compare MySQL LOCATE(), INSTR(), and POSITION() to find a substring’s 1-based position, including argument order and start-position behavior.

MySQL Error 1040: Too Many Connections

Recover from MySQL Error 1040 with an administrator connection, inspect sessions, and size application pools against max_connections.

MySQL Error 1206: Lock Table Full

Fix MySQL Error 1206 by shrinking oversized transactions, batching row changes, checking query indexes, and sizing the InnoDB buffer pool.