As far as i understood the SCRIPT command, it will backup the whole database. In my special case i don't want this. I just want to backup for example every row with name = "test".
But i think i found a proper solution for my needs. I'll export select results to a csv file. kind regards Richie On 8 Feb., 14:19, Panayiotis Vlissidis <[email protected]> wrote: > No problem. > > I think the script command will suit your > needs:http://www.h2database.com/html/grammar.html?highlight=scriptCompressi... > > 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.
