/SQL/Create temporary table in mysql

Create temporary table in mysql

Create temporary table in mysql

CREATE TEMPORARY TABLE new_tbl SELECT * FROM orig_tbl LIMIT 0;

2

Source: dev.mysql.com

How to view created temporary tables in mysql

 SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_TEMP%';

0

Source: stackoverflow.com

Similar codes

3 votes229 views1 answer
Postgres count distinct
SQL
1 vote219 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote191 views1 answer
Opensuse status MySQL
SQL
0 vote216 views1 answer
Oracle list subpartitions
SQL
13 votes359 views4 answers
Sql joining 3 tables
SQL
1 vote224 views1 answer
How to start with sql
SQL
0 vote216 views1 answer
User defined variables in sql
SQL
0 vote232 views1 answer
Mysql bind-address default value
SQL
10 votes218 views4 answers
Inner join in update query mysql
SQL
0 vote201 views1 answer
How to to get current date and time in sql
SQL

Share