mysql: what is a temporary table?
Posted
by every_answer_gets_a_point
on Stack Overflow
See other posts from Stack Overflow
or by every_answer_gets_a_point
Published on 2010-05-21T21:21:49Z
Indexed on
2010/05/21
21:30 UTC
Read the original article
Hit count: 127
what is the purpose of a temporary table like in this statement? how is it different than a regular table?
CREATE TEMPORARY TABLE tmptable
SELECT A.* FROM batchinfo_2009 AS A, calibration_2009 AS B
WHERE A.reporttime LIKE '%2010%'
AND A.rowid = B.rowid;
© Stack Overflow or respective owner