C170 Performance
Latest uploads at C170 Performance. Looking for notes at C170 Performance? We have lots of notes, study guides and study notes available for your school.
-
2
- 0
- 0
All courses for C170 Performance
-
C170 Performance 2
Latest content C170 Performance
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•C170 Performance
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•C170 Performance