C170 - Performance Assessment
Latest uploads at C170 - Performance Assessment. Looking for notes at C170 - Performance Assessment? We have lots of notes, study guides and study notes available for your school.
- 0
- 0
- 0
All courses for C170 - Performance Assessment
-
C170 Performance Assessment 3
Latest content C170 - Performance Assessment
Syntax for updating a specific column in a specific row - UPDATE <table> SET <atrribute> = <value> WHERE <primary key> = <value>; Syntax for deleting a row - DELETE FROM <TableName> WHERE <PrimaryKey> = <#>; Syntax for creating a view - CREATE VIEW <name> AS SELECT <columnname> CONCAT (<attribute>, ' ', <attribute>) AS <newname>, <attributes> FROM <tablename> Syntax to create an Index - CREATE IN...
- Exam (elaborations)
- • 2 pages's •
-
C170 Performance Assessment•C170 Performance Assessment
C170 Performance Assessment Complete 2023 Syntax for updating a specific column in a specific row Ans- UPDATE <table> SET <atrribute> = <value> WHERE <primary key> = <value>; Syntax for deleting a row Ans- DELETE FROM <TableName> WHERE <PrimaryKey> = <#>; Syntax for creating a view Ans- CREATE VIEW <name> AS SELECT <columnname> CONCAT (<attribute>, ' ', <attribute>) AS <newname>, <attributes> FROM <...
- Exam (elaborations)
- • 2 pages's •
-
C170 Performance Assessment•C170 Performance Assessment