Cloud Database Development and Management

138  ◾  Cloud Database Development and Management

In the above code, WHERE specifies the value to be updated. Without the WHERE

clause, all the values in the same column will be updated. e SET keyword is used to set a

new value.

4.5.3 Querying Data

e following example shows how to query the information about the employees with the last

name Smith:

SELECT FirstName, LastName

FROM EMPLOYEE

WHERE LastName = 'Smith'

4.5.4 Deleting Data

In the following example, you will delete the row where the employee’s last name is Chen:

DELETE FROM EMPLOYEE

WHERE LastName = 'Chen'

Again, the WHERE clause is necessary to specify which row to be deleted. Otherwise, a ...