dcsimg
 

Submitted by: M S Sridhar(sridhar.ms@gmail.com)

Friday Jun 22nd 2018 by M S Sridhar

Language: SQL, Expertise: Intermediate - See how to use a temporary table in MySQL.

We may want to use a table to store values while computing, which in turn might be used by subsequent processing. But, for sure, this working data must not be stored in an actual table that is part of the product. MySQL has a solution with TEMPORARY tables.

These tables are created using TEMPORARY and are visible for the current session only and thereafter cease to exist.

Syntax:

CREATE TEMPORARY TABLE new_table
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved