Thanks, but i would like to do it into my programm, i mean in java code.
all this is because I want to update database to this new version and I
don't know how to do it..
I suppose I can do it by using linked tables or merging them, but I don't
know the entire process.
El 12/06/2012 16:58, "Simon Melcher" <[email protected]>
escribió:
> hi,
>
> 1) use a tool such as squirrel SQL and create a data script of the old
> table. execute it by replacing the table name.
>
> 2)
> don't know how to handle it with the date field. but if you use a
> timestamp field instead of a date field you could do something like that:
> INSERT INTO tablename (id,key,title,category,year) VALUES (0, 0,
> 'movietitle', 'moviecategory', PARSEDATETIME('2012','yyyy', 'en', 'GMT'));
> look at the parsedatetime function for more information:
> http://www.h2database.com/html/functions.html#parsedatetime
>
>
>
>
> On Tue, Jun 12, 2012 at 4:39 PM, vicenrico <[email protected]> wrote:
>
>> Hello!.
>> I'm a software developer who has a program to catalog movies.
>> I have two questions that I would like you to ask me, please.
>> My program is currently version 1.0.
>> I have a table, for example:
>>
>> Table (long id, long key, String title, String category, Date year )
>>
>> I would like to import data from older versions, as could be, for
>> instance:
>>
>> TableOld ((long id, long key, String title, String year)
>>
>> Of course, my tables have a lot of columns, but I think with these you
>> can undertand what my problem is.
>>
>> My questions:
>>
>> I want to import old data (tableold) to my current database which is
>> already open (with ist own tables already created).
>>
>> 1) What is the best way to import data from tableold( a *data.db file in
>> my computer) to Table (that is currently opened). Should I use merge, or
>> create linked tables?
>> 2) In the "year" case, in my old db was a String , but I want to convert
>> to Date when doing the import. Is there a good way to convert "on the fly",
>> I mean, while importing?
>>
>> Thanks
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msg/h2-database/-/4YIJwRCXW74J.
>> 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.
