Digital Marketing

Loading...

Different types of SQL tables


  1. Permanent tables (i.e., created using the create table statement)
  2. Derived tables (i.e., rows returned by a sub-query and held in memory)
  3. Temporary tables (i.e., volatile data held in memory)
  4. Virtual tables (i.e., created using the create view statement)

Comments

Post a Comment

Popular posts from this blog

MySQL Sandbox with the Sakila sample database

You can go to https://www.katacoda.com/mysql-db-sandbox/scenarios/mysql-sandbox to access the MySQL Sandbox, which has the Sakila sample database loaded in a MySQL instance. You’ll have to set up a (free) Katacoda account. Then, click the Start Scenario button. See also: https://dev.mysql.com/doc/index-other.html
Read more