[NEW] CREATE TABLE AS SELECT...

Ruslan Zasukhin sunshine at public.kherson.ua
Fri Sep 29 10:11:49 CDT 2006


Hi All,

I want catch attention of this new feature in 2.4.3

You can now create table as result of SELECT query in one table.

* one of the best advantages here is ability to clone STRUCTUR of existed
table:

    CREATE RAM TABLE T2 AS
        SELECT * FROM T1 WHERE false   // without records

* or you can select some fields only and some records.

* or do join and copy its result into new table...


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list