Tank you, I didn't know I could use function for default value (I think I can't in MySQL that's why I didn't think to this solution).
Le samedi 10 août 2013 13:55:29 UTC+2, Noel Grandin a écrit : > > Something like this might work: > > CREATE TABLE TEST ( id INT, name TEXT, discovered TIMESTAMP DEFAULT > CURRENT_TIMESTAMP(), attributes TEXT) > > MERGE INTO TEST(id, name, attributes) KEY(id) VALUES (1, "xxx", "yyy") > > But if you want to control the timestamp yourself, then there is no > standard way to do that in SQL in a single statement. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
