/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

0 vote122 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote123 views1 answer
Downgrading sql localdb visual studio
SQL
16 votes143 views1 answer
Mysql smallint range
SQL
3 votes129 views2 answers
How to load files in mysql
SQL
0 vote156 views1 answer
Mysql best varchar length size
SQL
0 vote155 views2 answers
Check if sql temp table exists
SQL
0 vote131 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote128 views1 answer
Renommer schema sql
SQL
0 vote119 views1 answer
Access refused mysql xampp server
SQL
0 vote136 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL

Share