Computer Science > QUESTIONS & ANSWERS > C170 Performance Assessment Questions and answers, 100% Accurate, graded A+ (All)
C170 Performance Assessment Questions and answers, 100% Accurate, graded A+
Document Content and Description Below
C170 Performance Assessment Questions and answers, 100% Accurate, graded A+ Syntax for updating a specific column in a specific row - ✔✔-UPDATE <table> SET <atrribute> = <value> WHERE <prima ... ry 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 INDEX <indexname> ON <table> (<attribute); Syntax for inserting rows into a table - ✔✔-INSERT INTO <TableName> (ColumnName1, ColumnName2, ColumnName3) VALUES (Column1Value, Column2Value); Syntax for updating a value in a specific row - ✔✔-UPDATE <TableName> SET <Attribute> = <NewValue> WHERE <PrimaryKey> = <#> [Show More]
Last updated: 2 years ago
Preview 1 out of 2 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$4.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Mar 16, 2023
Number of pages
2
Written in
All
Additional information
This document has been written for:
Uploaded
Mar 16, 2023
Downloads
0
Views
90
