No problem. I think the script command will suit your needs: http://www.h2database.com/html/grammar.html?highlight=scriptCompression&search=script#firstFound
Best regards, Panayiotis Vlissidis On Tue, Feb 8, 2011 at 1:31 PM, Richie <[email protected]> wrote: > Sorry for not being clearly, but i meant backup(export) specific data > into a file for example. > Basicly i want to do a "SCRIPT DROP To <backup_file>" but qualified by > a specific WHERE clause. > > Is this possible or do i have to write something on my own to do a > export like this? > > kind regards > > Richie > > On 8 Feb., 11:37, Panayiotis Vlissidis <[email protected]> wrote: > > 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&sea... > > > > 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. > > -- 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.
