@ialgorithmia/stylusdb-sql
v1.0.1
Published
A minimal SQL based DB based on CSV files.
Downloads
4
Readme
Javascript based Stylus DB implementation Here is a list of basic SQL commands:
SELECT: Retrieve data from one or more tables. Example - SELECT column1, column2 FROM table_name WHERE condition;
INSERT: Insert new records into a table. Example - INSERT INTO table_name (column1, column2) VALUES (value1, value2);
UPDATE: Modify existing records in a table. Example - UPDATE table_name SET column1 = value1 WHERE condition;
DELETE: Remove records from a table. Example - DELETE FROM table_name WHERE condition;
CREATE TABLE: Create a new table with specified columns and data types. Example - CREATE TABLE table_name ( column1 datatype, column2 datatype, ... );
ALTER TABLE: Modify an existing table (e.g., add or drop columns). Example - ALTER TABLE table_name ADD column_name datatype;
DROP TABLE: Delete an existing table