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 |
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
+ Add
- Subtract
* Multiply
/ Divide
% Modulo
& Bitwise AND
| Bitwise OR
^ Bitwise exclusive OR
= 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