If by backup you mean backing up the results of a query to another table within the database then I guess the CREATE TABLE ... AS SELECT... clause is what you are looking for.
If so, have a look here: http://www.h2database.com/html/grammar.html?highlight=create%2Cta&search=create%20ta#create_table Best regards, Panayiotis Vlissidis On Tue, Feb 8, 2011 at 10:30 AM, Richie <[email protected]> wrote: > Hi! > > I am trying to create a specific backup of my h2 db. Therefore I'd > like to backup for example the Result from a Select Statement like > > SELECT LastName,Firstname > INTO Persons_Backup > FROM Persons > WHERE City='Sandnes' > > Unfortunately a statement of this kind is not possible. Is there a > workaround to perform the same result as the statement above? > > kind regards > > Richie > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
