Search⌘ K
AI Features
Home
Courses
SQL Interview Preparation

Answer: Update a Value

Explore how to update values in SQL tables using the UPDATE statement alongside SET and WHERE clauses to selectively modify data. Understand different techniques including subqueries, joins, and session variables for varied scenarios. Practice applying these concepts to efficiently update records based on conditions.

We'll cover the following...

Solution

The solution is given below:

MySQL
/* The UPDATE statement to update a record */
UPDATE Employees
SET    Salary = 55000
WHERE  EmpName = 'Sarah Ronald';
/* Retrieve the records from the Employees table where EmpID is 4 */
SELECT * FROM Employees
WHERE  EmpID = 4;

Explanation

The explanation of the solution code is given below:

  • Line 2: The UPDATE statement begins with the UPDATE keyword followed by a table name that will be modified.

  • Line 3: The SET clause specifies the column(s) and new values.

  • Line 4: The WHERE clause filters the record(s) in the table to determine which record we want to update based on the specified condition.

  • Line 7: The SELECT ...