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;

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

Previous Session:

Previous Session | Notes

Related Posts