Question

Which SQL keyword is used to change a column value?

a) CHANGE
b) INSERT
c) SELECT
d) SET
e) MODIFY

Answer 1

The SQL keyword to change a column value is 'SET', commonly used in an 'UPDATE' statement to modify data within a table. A WHERE clause is used to specify which records to update.

Step-by-step explanation:

The SQL keyword used to change a column value is SET. This keyword is typically used in an UPDATE statement which allows you to modify existing data within a table. For example, if you want to change the value of a 'salary' column for a particular employee in an 'employees' table, your SQL query would look something like:

UPDATE employees
SET salary = 50000
WHERE employee_id = 1;

The WHERE clause specifies which record or records should be updated with the new value. If you omit the WHERE clause, all records in the table will be updated.