Pixeltests
0 Comments
SQL Made Easy for AI – Day 2
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: