Hi,
This is supported in the current version. See
http://www.h2database.com/html/grammar.html#update
UPDATE tableName SET {columnName= {DEFAULT | expression} } [,...]
[WHERE expression]
> but this isn't working in my version of h2 (2006-08-31).
That's a very old version.
> I have just downloaded the 2009-09-04 version of h2, but the SQL syntax
>doesn't
> show any change to the UPDATE command
I think it does. See above.
Regards,
Thomas
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
