#Minisql A very simple local relational database implementation. A small sql server.
Just for learning the details of a database.
-- ##Commands To be easy, the command of Minisql is a little different from the classic sql command. Only support int \ float \ char(n).
All index is for single-attribute and single-value. Minisql will create index on the primary key automatically. Users can create index on unique attribute.
create table tableName( attributeName type, attributeName type, attributeName type, ... primary key (attributeName) ); drop table tableName; create index indexName on tableName(attributeName); drop index indexName; select * from tableName; select * from tableName where condition1; select * from tableName where condition1 and condition2; condition represents that attribute op value, where op is > <> = >= <=. insert into tableName values(value1, value2); delete * from tableName; delete * from tableName where condition; quit; execfile file; # exec the sql queries in the file. --