Via Lattanzio,23 Milano
+39 02 36592025
info@synaptica.info

How to create a table from a select

How to create a table from a select

sometime happen that you need to create a table from a query…
now we can assume that you have old_table and you wanna build a copi of entire data into another table new_table

This operation is not a standard sql but a lot DataBases can do this :

in Oracle you can do this like “create table as” :

in MS Sql Server with this command :

in mySql you can do this like (the only difference between Oracle is the “as” statement) :

Firebird don’t support this operation

for Oracle and Interbase we need to extend to temporary dynamic tables, and transactions interactions … for those we need an extension of this article…

i know that is simple, but only for reminder..
tnkx
i

Tags: , , , , , , , ,

Lascia un commento