Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Basic SQL Syntax Rules


This chapter presents the basic units of the SQL language and the simplest relationships between them.

The following units are considered:

Syntax unit
Summary
Section
Characters
Basic language symbols: letters, digits, special characters.
Identifiers
SQL identifiers, host variable names.
Data types
Character, exact numeric, approximate numeric, date, time, timestamp, interval. Datetime and interval arithmetic.
Literals
Character, integer, decimal, floating point, date, time, timestamp, interval.
Assignments
Character, numeric, datetime and interval assignments. Data type conversions.
Comparisons
Character, numeric, datetime and interval comparison rules.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX