WGU Data Management - Applications - C170 OA GSA1
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 n_name = n_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, .... );
Información del documento
- Subido en
- 28 de mayo de 2024
- Número de páginas
- 2
- Escrito en
- 2023/2024
- Tipo
- Examen
- Contiene
- Preguntas y respuestas
