Developer: Jin Zhang / Haobo Wang

SQL Example

• Create Table:
  

  create table [Table Name] (
    [Attribute1] [type],
    [Attribute2] [type],
    ...
    primary key([Attribute?])
    );

• Create Index:
  

  create Index [Index Name] on [Table Name] ([Attribute])

• Select:
  

  select * from [Table Name] ( where [Attribute] [Condition] [Value] );

• Delete:
  

  delete from [Table Name] ( where [Attribute] [Condition] [Value] );

• Drop Table:
  

  Drop [Table Name];

• Drop Index:
  

  Drop [Index Name];

• Execfile:
  

  execfile [File Name];

Condition:{ '>' '<' '=' '<>' '>=' '<=' }

Type:{ char float int }

Other Integrity:{ unique 'primary key' }

Do not miss ' ' and sometimes '\n' will make some mistakes.