SQL

mysql update

UPDATE table_name SET column1=value1, column2=value2 WHERE condition

MySQL Update

UPDATE Customers SET City='Oslo'

mysql update

UPDATE Table_name
-- The desired value
SET Column_name = desired_value
-- Any value, of the item, of which one value you want to change
WHERE Column_name = value

alter table query in mysql

ALTER TABLE `employees`CHANGE `emp_id` `emp_id` int(11) NULL;

mysql update

UPDATE table_name SET field1 = new-value1, field2 = new-value2
[WHERE Clause]