<

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.


syntax


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.


syntax

UPDATE table   
SET Column_Name = 'YYYY-MM-DD HH:MM:SS'  
WHERE Id = value  

















© copyright 2017-2022 Completedone pvt ltd.