[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hsqldb-user
Subject:    Re: [Hsqldb-user] Is it possible to copy a table?
From:       "fredt" <fredt () users ! sourceforge ! net>
Date:       2009-04-22 13:13:05
Message-ID: 442FC6D691764182BA40637AE4611E87 () BLACK
[Download RAW message or body]

In version 1.8, you can use

SELECT * INTO newtable FROM oldtable

In version 1.9 you should use

CREATE newtable AS (SELECT * FROM oldtable)

----- Original Message ----- 
From: "AJRames" <aj@trash-mail.com>
To: <hsqldb-user@lists.sourceforge.net>
Sent: 21 April 2009 15:14
Subject: [Hsqldb-user] Is it possible to copy a table?



Hi.
Is it possible to copy a table in hsqldb with its content?
When it's possible, how?

Thanks!
-- 
View this message in context: 
http://www.nabble.com/Is-it-possible-to-copy-a-table--tp23157034p23157034.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.


------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user 


------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and 
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today. 
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/hsqldb-user
[prev in list] [next in list] [prev in thread] [next in thread]