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.

Related Posts:

  1. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  2. MySQL – UPDATE query based on SELECT Query
  3. MySQL Select Multiple VALUES
  4. MySQL Rank & $wpdb
  5. How to search usermeta table
  6. SELECT statement wrong?
  7. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  8. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  9. How to use mysqli_query() in PHP?
  10. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  11. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  12. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  13. Column count doesn’t match value count at row 1
  14. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  15. MySQL string replace
  16. Cannot add or update a child row: a foreign key constraint fails
  17. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  18. String concatenation in MySQL
  19. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  20. Cannot add or update a child row: a foreign key constraint fails
  21. MySQL Error “Operand should contain 1 column”
  22. MySQL create table if not exists and insert record only if table was created
  23. How to use MySQL DECIMAL?
  24. Access denied for user ‘root@localhost’ (using password:NO)
  25. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  26. How to make MySQL table primary key auto increment with some prefix
  27. Access denied for user ‘root@localhost’ (using password:NO)
  28. MySQL ERROR 1290 (HY000) –secure-file-priv option
  29. MySQL error 2006: mysql server has gone away
  30. Which MySQL data type to use for storing boolean values
  31. sql query with multiple where statements
  32. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  33. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  34. Cannot delete or update a parent row: a foreign key constraint fails
  35. Cannot delete or update a parent row: a foreign key constraint fails
  36. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  37. MySQL server startup error ‘The server quit without updating PID file’
  38. Rename a column in MySQL
  39. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  40. Cannot delete or update a parent row: a foreign key constraint fails
  41. MySQL server startup error ‘The server quit without updating PID file’
  42. How do I restore a dump file from mysqldump?
  43. Syntax error due to using a reserved word as a table or column name in MySQL
  44. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  45. MySQL root password change
  46. Installation of MySQL for Visual Studio 1.2.8 failed
  47. Not unique table/alias
  48. How do I import an SQL file using the command line in MySQL?
  49. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  50. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  51. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  52. Your password does not satisfy the current policy requirements
  53. How do I quickly rename a MySQL database (change schema name)?
  54. What does SQL Select symbol || mean?
  55. Install mysql-python (Windows)
  56. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  57. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  58. SQL – Update multiple records in one query
  59. What is the definition of cardinality in SQL
  60. How to restart remote MySQL server running on Ubuntu linux?
  61. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  62. MySQL DROP all tables, ignoring foreign keys
  63. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  64. When to use SELECT … FOR UPDATE?
  65. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  66. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  67. Setting up foreign keys in phpMyAdmin?
  68. Select from multiple tables without a join?
  69. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  70. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  71. MySQL SELECT increment counter
  72. SQL Query Where Field DOES NOT Contain $x
  73. Create a new database with MySQL Workbench
  74. Duplicating a MySQL table, indices, and data
  75. Disable ONLY_FULL_GROUP_BY
  76. what does “/index.php?admin/admin_dashboard” in my url mean
  77. Column ‘user_id’ in field list is ambiguous
  78. How to join two tables by multiple columns in SQL?
  79. MySQL “Or” Condition
  80. How to get size of mysql database?
  81. mysql Foreign key constraint is incorrectly formed error
  82. Database sharding vs partitioning
  83. Selecting data from two different tables without using joins
  84. MySQL WHERE IN ()
  85. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  86. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  87. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  88. SQL – Update multiple records in one query
  89. Difference between VARCHAR and TEXT in MySQL
  90. mysql is not recognised as an internal or external command,operable program or batch
  91. 1052: Column ‘id’ in field list is ambiguous
  92. Escape string Python for MySQL
  93. 1052: Column ‘id’ in field list is ambiguous
  94. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  95. MySQL: Invalid use of group function
  96. SELECT list is not in GROUP BY clause and contains nonaggregated column …. incompatible with sql_mode=only_full_group_by
  97. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  98. difference between primary key and unique key
  99. mysqladmin: connect to server at ‘localhost’ failed
  100. mysql update multiple columns with same now()

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)