Create a global temporary table in mysql

Asked Dec 02 '14 at 12:42

Active Oct 31 '16 at 10:14

Viewed 2,393 times

I would like to create the equivalent of this query (Oracle) in MySQL Can anyone help?

CREATE GLOBAL TEMPORARY TABLE TEMP_TEST
(
  id   VARCHAR2(50),
  id_age  NUMBER(38)
) ON COMMIT DELETE ROWS;

edited Oct 31 '16 at 10:14

asked Dec 02 '14 at 12:42

akaliza

3

Is this any help? http://dba.stackexchange.com/questions/42766/creating-a-global-temp-table-in-mysql – Alex Szabo Dec 02 '14 at 12:44
Perhaps this is helpful, you can mention the TEMPORARY keyword in your create statement? http://stackoverflow.com/questions/5859391/create-a-temporary-table-in-a-select-statement-without-a-separate-create-table – Sirius Oct 31 '16 at 10:25

0 Answers0