Skip to content

callMeName/MiniSql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

29 Commits
 
 
 
 
 
 

Repository files navigation

#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.

--

About

Our MiniSql project. A small sql server

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages