‍

‍
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;

To increase your AI opportunities, book a free AI career consultation call and unlock the potential of AI.‍

‍

‍

‍

Previous Session:

Previous Session | Notes

‍