https://mariadb.com/docs/server/reference/sql-statements/data-manipulation/selecting-data/subqueries/subqueries-in-a-from-clause-derived-tables
Subqueries in a FROM Clause (Derived Tables) | Server | MariaDB Documentation
Use a subquery as a temporary table. Derived tables allow you to select from the result set of another query within the FROM clause.
tables server mariadbclause
https://mariadb.com/docs/server/security/limiting-size-of-created-disk-temporary-files-and-tables/limiting-size-of-created-disk-temporary-files-and-tables-overview
Limiting Size of Created Disk Temporary Files and Tables Overview | Server | MariaDB Documentation
Overview of the feature introduced in MariaDB 11.5 to limit disk space used by temporary files and internal on-disk temporary tables to prevent disk exhaustion.
created disk temporarysize
https://mariadb.com/docs/server/reference/sql-structure/temporal-tables/system-versioned-tables
System-Versioned Tables | Server | MariaDB Documentation
Complete system-versioned tables: WITH SYSTEM VERSIONING syntax, FOR SYSTEM_TIME AS OF/BETWEEN/ALL queries, and ROW_START/ROW_END columns.
tables server mariadbsystem