‍

‍
Table Manipulation

‍

Queries Used:
‍

CREATE TABLE table_name (
 column1 datatype,
 column2 datatype,
 column3 datatype
);

-- Insert into columns in order:
INSERT INTO table_name
VALUES (value1, value2);

-- Insert into columns by name:
INSERT INTO table_name (column1, column2)
VALUES (value1, value2);

ALTER TABLE table_name
ADD column_name datatype;

DELETE FROM table_name
WHERE some_column = some_value;

UPDATE table_name
SET column1 = value1, column2 = value2
WHERE some_column = some_value;

‍

Previous Session:

Link: https://youtube.com/live/rpvgN0fWmx8

Notes:  https://www.pixeltests.com/blog/sql-day1

‍