Question

How can you change "Thomas" into "Michel" in the "LastName" column in the Users table?

Select the correct answer from below options:

a) UPDATE User SET LastName = 'Thomas' INTO LastName = 'Michel'

b) MODIFY Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

c) MODIFY Users SET LastName = 'Thomas' INTO LastName = 'Michel'

d) UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

Answer 1

d) UPDATE Users SET LastName = 'Michel' WHERE LastName = 'Thomas'

The UPDATE statement is used for modifying the table data by using the SET and WHERE clause. The SET clause is used to change the values of the column specified in the WHERE clause. See the below syntax:

UPDATE table SET column1 = expression1, column2 = expression2,... WHERE conditions