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

What is storage manager, What is storage manager?  A  storage  manager ... What is storage manager?  A  storage  manager  is  a  program  module  that  gives  the  interface  between the Low level data  kept in a database and the application programs

Which is a valid sql type, Which is a valid SQL type? A valid SQL Shoul... Which is a valid SQL type? A valid SQL Should be in CHARACTER it is should be NUMERIC and FLOAT.

Explain the advantages of database management system, Advantages of Databas... Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i

Physical or internal level, give me a diagram about physical or internal le... give me a diagram about physical or internal level

Generalization and specialization, design a generalization specialization h... design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

Explain natural join, Explain natural join? Natural Join - Similar as... Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

Explain heap file with advantages, Explain heap file with advantages? H... Explain heap file with advantages? Heap File is an unordered set or a group of records, stored on a set of pages. This class gives basic support for inserting, updating, select

Sql, sql is relationally complete-justify sql is relationally complete-justify

System error-database errors, System error :These contain errors in databas... System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys

Define the basic operations of the relational algebra, Define the basic ope... Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot