SQL Made Easy for AI - Day 2
February 9, 2023
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