Using Temporary Tables for Intermediate Results and Simplification
In this video, Alejandro Duarte (Developer Relations Engineer at MariaDB) demonstrates MariaDB's temporary tables. This is useful when moving data from one table to another, transforming data, computing intermediate results, and simplifying complex queries.
►Try MariaDB today: https://mariadb.com/downloads/
Table of Contents
0:00 Intro
0:10 Permanent tables
0:34 Temporary tables
1:14 Temporary ≠ temporal
1:25 Copying table schema
2:01 Copying data
3:07 Outro
►Follow Alejandro on Twitter: / alejandro_du
►Follow MariaDB on Twitter: / mariadb
►Subscribe to the MariaDB channel:
/ mariadb
►Explore MariaDB Products: https://mariadb.com/products
►Check out the MariaDB DeveloperHub: https://mariadb.com/developers/
►Get in touch with MariaDB experts via Slack: https://mariadb-community.slack.com/ (invite: https://r.mariadb.com/join-community-...)
MariaDB is making a big impact on the world. Whether you’re checking your bank account, buying a coffee, shopping online, making a phone call, listening to music, taking out a loan, or ordering takeout–MariaDB is the backbone of applications used every day. Companies small and large, including 75% of the Fortune 500 run MariaDB, touching the lives of billions of people. With massive reach through Linux distributions, enterprise deployments, and public clouds, MariaDB is uniquely positioned as the leading database for modern application development.
#MariaDB #Database #Data #SQL