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.
