SyntaxFix

[mysql] Create a temporary table in a SELECT statement without a separate CREATE TABLE 

CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS (SELECT * FROM table1)

From the manual found at http://dev.mysql.com/doc/refman/5.7/en/create-table.html

You can use the TEMPORARY keyword when creating a table. A TEMPORARY table is visible only to the current session, and is dropped automatically when the session is closed. This means that two different sessions can use the same temporary table name without conflicting with each other or with an existing non-TEMPORARY table of the same name. (The existing table is hidden until the temporary table is dropped.) To create temporary tables, you must have the CREATE TEMPORARY TABLES privilege.

Examples related to mysql

• Implement specialization in ER diagram • How to post query parameters with Axios? • PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client • Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver' • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' is not supported • How to resolve Unable to load authentication plugin 'caching_sha2_password' issue • Connection Java-MySql : Public Key Retrieval is not allowed • How to grant all privileges to root user in MySQL 8.0 • MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

Examples related to select

• Warning: Use the 'defaultValue' or 'value' props on <select> instead of setting 'selected' on <option> • SQL query to check if a name begins and ends with a vowel • Angular2 *ngFor in select list, set active based on string from object • SQL: Two select statements in one query • How to get selected value of a dropdown menu in ReactJS • DATEDIFF function in Oracle • How to filter an array of objects based on values in an inner array with jq? • Select unique values with 'select' function in 'dplyr' library • how to set select element as readonly ('disabled' doesnt pass select value on server) • Trying to use INNER JOIN and GROUP BY SQL with SUM Function, Not Working

Examples related to temp-tables

• How to find difference between two columns data? • Temporary table in SQL server causing ' There is already an object named' error • SQL Server Creating a temp table for this query • Create a temporary table in MySQL with an index from a select • How can I simulate an array variable in MySQL? • When should I use a table variable vs temporary table in sql server? • Inserting data into a temporary table • TSQL select into Temp table from dynamic sql • dropping a global temporary table • Is there a way to get a list of all current temporary tables in SQL Server?

Examples related to create-table

• Field 'id' doesn't have a default value? • MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB • Create hive table using "as select" or "like" and also specify delimiter • #1064 -You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version • C# - Create SQL Server table programmatically • How do I create a table based on another table • Creating new table with SELECT INTO in SQL • create table in postgreSQL • PostgreSQL Error: Relation already exists • Mysql: Setup the format of DATETIME to 'DD-MM-YYYY HH:MM:SS' when creating a table

Examples related to derived-table

• Create a temporary table in a SELECT statement without a separate CREATE TABLE • SELECT INTO USING UNION QUERY • Create a SQL query to retrieve most recent records