Hello, I'm using H2 in embedded mode to execute unit tests, but my production DB is MySQL.
Everything works fine except that some SQL statements which work with MySQL don't with H2. This is the case of the multi-table delete: http://dev.mysql.com/doc/refman/5.0/en/delete.html Multiple-table syntax: DELETE [LOW_PRIORITY] [QUICK] [IGNORE] tbl_name[.*] [, tbl_name[.*]] ... FROM table_references [WHERE where_condition] As far as I understand, this is not standard SQL, but is there any change that this is supported in a future release of H2? For the moment, we solved this by doing the join in Java but this a not very efficient and my colleagues are not very happy with that. Oh yes, same question with the multiple-table update :) Thanks, Boris. -- 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.
