These fields are data elements maintained by the engine itself but are accessed using a normal select call. Some of the data pertains to an entire table, some to a particular row, and some to the current session. An internal value used to identify a row based on its location. The username associated with the session over which the query was submitted Sequences To overcome the problem of trying to manage sequences in client application code, mSQL 2.0 provides in-build, atomic operations for accessing and managing sequences. A sequence is a numeric counter that is automatically adjusted to the next value in the sequence each time it is accessed.
Any table can have a sequence created for it but a table can only contain a single sequence.
The current sequence value is returned and the sequence is updated to the next value in the sequence. Access to and modification of the sequence is atomic. Regular Expressions ANSI SQL defines a very simple regular expression language for use in matching data with the LIKE operator. Most queries will require only the simple functionality offered by the standard SQL LIKE but the extended functionality is retained for compatibility. It should be noted that the new LIKE operator is much faster than the full UNIX version offered by 1.x.