WGU D426/D427 Syntax
Study online at https://quizlet.com/_fx3u8q
1. List all Databases: SHOW DATABASES;
2. List all Tables in a database: USE Database;
SHOW TABLES;
3. List all columns and their properties in a table: SHOW COLUMNS
FROM TableName;
4. Create a Table: CREATE TABLE TableName (
ColumnName1 DataType,
ColumnName2 DataType,
ColumnName3 DataType,
...
);
5. Add a column to a table: ALTER TABLE TableName
ADD ColumnName DataType;
6. Modify a column in a table: ALTER TABLE TableName
CHANGE CurrentColumnName NewColumnName DateType;
7. Remove a column from a table: ALTER TABLE TableName
DROP ColumnName;
8. Aggregate function (single value output): SELECT Function(Column) AS NewColumnName
FROM TableName;
9. Aggregate function (multi-value (summary) output): SELECT LabelsColumn, FUNC-
TION(DataColumn)
FROM TableName
GROUP BY LabelsColumn;
10. Insert new data into a table (all columns): INSERT INTO TableName
VALUES (Value1, Vaule2, Value3....);
11. Insert new data into a table (not all columns): INSERT INTO TableName (Column1, Column2,
Column3....)
VALUES (Value1, Value2, Value3....);
12. Insert multiple rows of data (not all columns): INSERT INTO TableName (Column1, Column2,
Column3....)
VALUES (Value1, Value2, Value3....),
1/4
Study online at https://quizlet.com/_fx3u8q
1. List all Databases: SHOW DATABASES;
2. List all Tables in a database: USE Database;
SHOW TABLES;
3. List all columns and their properties in a table: SHOW COLUMNS
FROM TableName;
4. Create a Table: CREATE TABLE TableName (
ColumnName1 DataType,
ColumnName2 DataType,
ColumnName3 DataType,
...
);
5. Add a column to a table: ALTER TABLE TableName
ADD ColumnName DataType;
6. Modify a column in a table: ALTER TABLE TableName
CHANGE CurrentColumnName NewColumnName DateType;
7. Remove a column from a table: ALTER TABLE TableName
DROP ColumnName;
8. Aggregate function (single value output): SELECT Function(Column) AS NewColumnName
FROM TableName;
9. Aggregate function (multi-value (summary) output): SELECT LabelsColumn, FUNC-
TION(DataColumn)
FROM TableName
GROUP BY LabelsColumn;
10. Insert new data into a table (all columns): INSERT INTO TableName
VALUES (Value1, Vaule2, Value3....);
11. Insert new data into a table (not all columns): INSERT INTO TableName (Column1, Column2,
Column3....)
VALUES (Value1, Value2, Value3....);
12. Insert multiple rows of data (not all columns): INSERT INTO TableName (Column1, Column2,
Column3....)
VALUES (Value1, Value2, Value3....),
1/4
