1. CREATE TABLE students // create table
2. DELETE FROM table_name [WHERE condition];
3. UPDATE employees
SET city = 'Toronto',
state = 'ON',
postalcode = 'M5P 2N7'
WHERE
employeeid = 4;
4. DELETE FROM students
WHERE id = 2;
5. DROP TABLE IF EXISTS
6."SELECT * FROM " + Table
* testing Link - https://www.mycompiler.io/
//example
-- create a table
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
gender TEXT NOT NULL,
age INTEGER
);
-- RENAME students To studentss;
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M',1);
INSERT INTO students VALUES (2, 'Joanna', 'F',2);
INSERT INTO students VALUES (5, 'value2', 'value3',3);
-- fetch some values
SELECT * FROM students WHERE gender = 'F';
-- DELETE FROM students WHERE name = 'Ryan';
SELECT* FROM students;
