/SQL/Select into temp table

Select into temp table

Select into temp table

SELECT * 
INTO #temp
FROM (
    SELECT col1, col2
    FROM table1
) AS x

1

Source: stackoverflow.com

Select into temp table

SELECT t.col1, t.col2...
INTO #temp
FROM table1 AS t

0

Similar codes

0 vote218 views1 answer
View to table sql
SQL
0 vote230 views3 answers
Condition in count sql
SQL
8 votes189 views1 answer
How to remove tables from postgresql
SQL
0 vote255 views1 answer
Trigger stock phpmyadmin
SQL
5 votes216 views1 answer
Add column table sql default value
SQL
0 vote311 views3 answers
CONTACT FORM SQL
SQL
0 vote223 views1 answer
Postgresql port 5432 not open
SQL
0 vote198 views1 answer
Enable full text search mysql
SQL
0 vote220 views1 answer
How to change mysql port in xampp
SQL
2 votes211 views1 answer
Mysql id of inserted row
SQL

Share