5 Write an UPDATE statement that modifies the Customers tabl

5. Write an UPDATE statement that modifies the Customers table. Change the password column to “reset” for every customer in the table.

Solution

Answer :-

UPDATE CUSTOMERS SET PASSWORD =\'RESET\' ;

Explanation :

Update keyword will update all keywords data to the table and also a seperate record in the table by where keyword.