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