What is use of generating such tables? How can you create temporary tables?

When you require a table only for a short time after that you want it to disappear automatically you can go to generate a temporary table. This is extremely useful behaviour as you needn't remember to eliminate the table

 Temporary tables can be created using the keyword CREATETEMPORARY TABLE

 

Posted Date: 7/31/2013 2:13:09 AM | Location : United States

Ask an Expert

Related Discussions:- What is use of generating such tables, Assignment Help, Ask Question on What is use of generating such tables, Get Answer, Expert's Help, What is use of generating such tables Discussions

Write discussion on What is use of generating such tables
Your posts are moderated

Write your message here..

Related Questions

Databse Processing 12e, Chapter 10a review questions Chapter 10a review questions

Define page, Define page. The database is partitioned into some number ... Define page. The database is partitioned into some number of fixed-length blocks, which are referred to as pages.

Describe different steps of object-oriented design process, Describe differ... Describe different steps of the object-oriented design process.  The broad steps of the object-oriented design process are: a. Define context and modes of use of the system

What is natural language interfaces, What is Natural Language Interfaces? ... What is Natural Language Interfaces? Natural Language Interfaces - These interfaces accept requests written within English or a few other language and attempt to "understand" t

Advantages to copying records from one table to another, What kind of advan... What kind of advantages to copying records from one table to another? -) When an algorithm that modifies a table is used after that it's safer to work with the copy -) When

Write the motivations led to development of oo-dbms, Write the motivations ... Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Data warehousing and business intelligence, I need help with data warehousi... I need help with data warehousing and business intelligence course project about designing a data warehouse for a jewelry company that does not have one

Describe the concepts of structural semantic data model, Question 1 List a... Question 1 List and explain various Normal Forms. How BCNF differs from the Third Normal Form and 4th Normal forms? Question 2 Describe the concepts of Structural Semantic Da

Recovery techniques, Recovery Techniques: After Reading the types of failur... Recovery Techniques: After Reading the types of failures and database errors, let us talk about how to recover from the failures. Recovery can be complete using/restoring the previ

Delete - referential integrity, During the deletion of a tuple two cases ca... During the deletion of a tuple two cases can happen: Deletion of tuple in relation having the foreign key: In this type of case simply delete the desired tuple. For example, in