SQL commands usage

for now , is not recognized!

Types

• INT
• FLOAT
• STRING
• NULL

Operators

• =, !=, <, >, <=, >=

Table definitions

Create a table:

CREATE TABLE `table_name` (`col_1_name` [TYPE], `col_2_name` [TYPE], ...)

Update a table:

Not implemented yet!

Delete a table:

DROP TABLE `table_name`

List all tables stored:

LIST TABLE

Table content manipulation

Select data from a table:

SELECT `col_1_name`, `col_2_name`, ... 
FROM `table_name` 
WHERE `col_x_name` [OPERATOR] `value`

Insert data into a table:

INSERT INTO `table_name` VALUES `value1`, `value2`

value1 correspond to: col_1_name

Update data of a table:

Not implemented yet!

Delete data of a table:

DELETE * 
FROM `table_name` 
WHERE `col_x_name` [OPERATOR] `value`

Joins

Not implemented yet!