WGU Data Management - Applications - C170 OA
GSA1
Add New Row
INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, value3, ...);
Update Row
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
Delete Row
DELETE FROM table_name
WHERE condition;
Inner Join
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
CREATE VIEW
CREATE VIEW viewname AS
SELECT Col1, Col2
FROM table
WHERE condition;
Concatenate
CONCAT(Col1, Col2) AS NewColumnName;
Create Index
CREATE INDEX index_name
ON table_name (column1, column2, ...);
Create Database
CREATE DATABASE databasename;
Drop Database
DROP DATABASE databasename;
Create Table
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);
GSA1
Add New Row
INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, value3, ...);
Update Row
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
Delete Row
DELETE FROM table_name
WHERE condition;
Inner Join
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
CREATE VIEW
CREATE VIEW viewname AS
SELECT Col1, Col2
FROM table
WHERE condition;
Concatenate
CONCAT(Col1, Col2) AS NewColumnName;
Create Index
CREATE INDEX index_name
ON table_name (column1, column2, ...);
Create Database
CREATE DATABASE databasename;
Drop Database
DROP DATABASE databasename;
Create Table
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);
