Mini SQL 2.0 (Beta) Language Specifications

Introduction

The mSQL language offers a significant subset of the features provided by ANSI SQL. It

allows a program or user to store, manipulate and retrieve data in table structures. It does not

support some relational capabilities such as views and nested queries. Although it does not

support all the relational operations defined in the ANSI specification, it does provide the

capability of "joins" between multiple tables.

The definitions and examples below depict mSQL key words in upper case, but no such

restriction is placed on the actual queries.

The Create Clause

The create clause as supported by mSQL 2 can be used to create tables, indices, and sequences.

It cannot be used to create other definitions such as views. The three valid constructs of the

create clause are shown below:

CREATE TABLE table_name (

G   

col_name col_type [ not null ]

[ , col_name col_type [ not null ] ]**

)

CREATE [ UNIQUE ] INDEX index_name ON table_name (

field_name

[ , field_name ] **

)

CREATE SEQUENCE ON table_name [ STEP step_val ] [ VALUE initial_val ]

An example of the creation of a table is show below:

CREATE TABLE emp_details (

first_name char(15) not null,

last_name char(15) not null,

comment text(50),

dept char(20),

emp_id int

)

The available types are: 

char (len) String of characters (or other 8 bit data)