SQL Statements

NuoDB supports the following SQL statements:

Note: When running multiple sql statements as part of the same statement, it could occur that the output is eexcuted in an order different to what the user expects. For example:

create index i1 on t1 (a); update t1 set b = 5 where a = 6;

In the above instance, the index is created and the update is executed as part of the same statement. At the time that this update is compiled, the index will not yet exist and therefore will not be used.