This is a DatabaseSystem which have few features ,So we call it MicroDatabase.
cd ./src
make
./main
create table TABLE_NAME (COLUMN TYPE , ... COLUMN TYPE)
insert into TABLE_NAME values(VALUE, … VALUE)
select * from TABLE_NAME
select * from TABLE_NAME where COLUMN (<,>,=,!=) VALUE
delete from TABLE_NAME where COLUMN (<,>,=,!=) VALUE
drop table TABLE_NAME
exit
create table students (id int , name string ,age int)
insert into students values(1,"Tom",20)
insert into students values(2,"May",30)
select * from students where age > 10
delete from students where id = 1
drop table students
exit
- Optimization
- Cache data
- The program is allowed to type
select column1,column2,..., TABLE_NAME
. - Add some value types.For example
text,char,bool,time...