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

Filed under:
|

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

Related posts about mysql

Related posts about sql