SQL方言参考
Completion requirements
将 SELECT 查询的结果保存为新表
问题:将任意 SELECT 查询(SELECT 列 FROM 表 ...
)的结果保存为一个新的永久表 new_table
。
Save results from select query as new table
Problem: save results from an arbitrary SELECT query (SELECT columns FROM table ...) as a new permanent table new_table.
Standard | ? |
---|---|
DB2 | ? |
Firebird | ? |
Ingres | ? |
Linter | CREATE TABLE new_table AS SELECT columns FROM table ... |
MonetDB | CREATE TABLE new_table AS SELECT columns FROM table ... WITH DATA |
MSSQL | SELECT columns INTO new_table FROM table ... |
MySQL | CREATE TABLE new_table [AS] SELECT columns FROM table ... |
Oracle | CREATE TABLE new_table [AS] SELECT columns FROM table ... |
PostgreSQL |
|
SQLite | CREATE TABLE new_table [AS] SELECT columns FROM table ... |
Virtuoso | CREATE TABLE new_table [AS] SELECT columns FROM table ... |
Last modified: Friday, 11 April 2025, 2:32 PM