README.md

For data overview and query examples please go to Wiki

---

COMMON DATATYPE	Details
DECIMAL(M,N)	-- Decimal Numbers - Exact Value
INT	-- Whole Number
VARCHAR(l)	-- String of text of length
DATE	-- 'YYYY-MM-DD'
BLOB	-- Binary Large Object, Stores large data
TIMESTAMP	-- 'YYYY-MM-DD HH:MM:SS' - used for recording events

SQL Commands

SELECT - extracts data from a database
UPDATE - updates data in a database
DELETE - deletes data from a database
INSERT INTO - inserts new data into a database
CREATE DATABASE - creates a new database
ALTER DATABASE - modifies a database
CREATE TABLE - creates a new table
ALTER TABLE - modifies a table
DROP TABLE - deletes a table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index

SQL Arithmetic Operators

+	Add	
-	Subtract	
*	Multiply	
/	Divide	
%	Modulo

SQL Bitwise Operators

&	Bitwise AND
|	Bitwise OR
^	Bitwise exclusive OR

SQL Comparison Operators

=	Equal to	
>	Greater than	
<	Less than	
>=	Greater than or equal to	
<=	Less than or equal to	
<>	Not equal to	

More query examples in wiki: https://github.com/atomb0mb/sqlbasic/wiki

More external resource of SQL: https://www.w3schools.com/sql/sql_intro.asp