Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

Create temporary table from select statement without using Create Table

⇧
0
⇩
72 views

Is it possible to create a temporary (session only) table from a select statement without using a create table statement and specifying each column type? I know derived tables are capable of this, but those are super-temporary (statement-only) and I want to re-use.

It would save time if I did not have to write up a create table command and keep the column list and type list matched up.

mysql temporary-tables derived-table
asked May 2, 2011 11:03 am CDT
George Bailey
posted via StackOverflow

1 Answer

⇧
0
⇩
 

CREATE TABLE table2 AS (SELECT * FROM table1)

answered May 2, 2011 11:23 am CDT
pjskeptic

Your answer

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
How to create index for table having 30 columns where Select statement is generated dynamically
February 10, 2011
Create temporary table in Hive?
March 21, 2011
Can I change the datatype for the "Create Table" field in the Show Create Table function in MySQL?
January 10, 2011
Create table from select then alter table by adding an auto increment column in mysql
January 11, 2011
Mysql proxy to check create table statement
February 22, 2011
Foreign Key Error on MySQL CREATE TABLE statement (err: 150)
March 18, 2011
How to create multiple columns in one table in a single query statement in postgres?
March 10, 2011
MySQL table joins, nested select statements, or create a view?
February 17, 2011
How do I create this Select Statement?
February 22, 2011
Mysql statement to create user and table private to that user only
April 11, 2011
Mysql create table based on another table including indexes
January 25, 2011
Create a enum table and access it from other table in mysql
March 21, 2011
MySQL create table containing values from a column in another table.
January 28, 2011
Create new table from two tables with multiple columns in first table replaced by columns in second table
April 10, 2011
How to create temporary function in Postgres
February 14, 2011
Populating a table with a large amount of data from a temporary table - MySQL
January 5, 2011
Why I cannot create this table?
April 22, 2011
Create this table using my sql
February 1, 2011
Alter table failed because disc is full. How do I delete the temporary table that was being created to reclaim some space?
March 9, 2011
Insert into table from temporary table takes a long time
January 10, 2011
How to use constants in SQL CREATE TABLE?
December 31, 2010
Create table in hbase
February 22, 2011
How do I create this relational table??
March 16, 2011
I need to create a SQLite table...
February 17, 2011
Should I create an Index on my table?
April 18, 2011
C++, QT4 Sqlite: can't create table
February 15, 2011
SHOW CREATE TABLE
April 23, 2011
Create table mysql
April 15, 2011
MySQL create table
April 13, 2011
Create a temporary file, then upload it using FTP (Java webapp)
January 25, 2011