Skip to content

atomb0mb/sqlbasic

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 

Repository files navigation

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

About

Quick learn or review SQL knowledge

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published