SQL UPDATE: Examples

UPDATE employees 
SET 
    last_name = 'Lopez'
WHERE
    employee_id = 192;

SELECT
	employee_id,
	first_name,
	last_name
FROM
	employees
WHERE
	employee_id = 192;

SELECT
	*
FROM
	dependents
WHERE
	employee_id = 192;

UPDATE dependents 
SET 
    last_name = 'Lopez'
WHERE
    employee_id = 192;

UPDATE dependents
SET last_name = (
	SELECT
		last_name
	FROM
		employees
	WHERE
		employee_id = dependents.employee_id
);

SELECT * FROM countries;

SELECT * FROM departments;

SELECT * FROM dependents;

SELECT * FROM employees;

SELECT * FROM jobs;

SELECT * FROM locations;

SELECT * FROM regions;

Execute

Clear Beautify Minify

Reload