SQL UPDATE Statement
SQL UPDATE statement is used to change the data of the records held by tables. Which rows is to be update, it is decided by a condition.
SQL Update Syntax
UPDATE table_name SET [column_name1= value1,... column_nameN = valueN] [WHERE condition]
SQL UPDATE with JOIN
SQL UPDATE JOIN means we will update one table using another table and join condition.
UPDATE customer_table INNER JOIN Customer_table ON customer_table.rel_cust_name = customer_table.cust_id SET customer_table.rel_cust_name = customer_table.cust_name
SQL UPDATE DATE
If you want to update a date & time field in SQL, you should use UPDATE DATE query.
UPDATE table SET Column_Name = 'YYYY-MM-DD HH:MM:SS' WHERE Id = value