Sql updating multiple tables at once
The SQL standard supports temporary tables, which are for temporary data, and permanent base tables, which are for persistent data.
If the table definition statements includes ON COMMIT PRESERVE ROWS, then the contents are kept when a commit takes place.The full list of SQL reserved words is in the appendix Lists of Keywords .There are several user-defined properties to control the strict application of the SQL Standard in different areas.For example CUBE is a reserved words that is not currently supported by Hyper SQL and is allowed as a table or column name.You should avoid using such names as future versions of Hyper SQL are likely to support the reserved words and may reject your table definitions or queries.For example, the word POSITION is reserved as it is a function defined by the Standards with a similar role as in Java.
Hyper SQL does not currently prevent you from using a reserved word if it does not support its use or can distinguish it.
Some statements written for older versions may have to be modified.
Over 300 words are reserved by the standard and should not be used as table or column names.
Their data is held entirely in memory but any change to their structure or contents is written to the file are read the next time the database is opened, and the MEMORY tables are recreated with all their contents.
So unlike TEMPORARY tables, MEMORY tables are persistent.
Hyper SQL 2.x supports the dialect of SQL defined by SQL standards 92, 1999, 2003, 20.