SQL
UPDATE Statement

UPDATE statement is used to edit the records of a table.

with WHERE

Syntax
Copy Code 


 

    UPDATE table_name
    SET column1 = value1, column2 = value2, ...
    WHERE condition;
Example
Copy Code 


  UPDATE Customers
	SET CustomerName = 'john', City= 'Austria'
	WHERE CustomerID = 6;

without WHERE

Whenever we use UPDATE Statement without WHERE clause it will Update all the records in the table.

Syntax
Copy Code 



    UPDATE table_name
    SET column1 = value1, column2 = value2...;
Example
Copy Code 


 

  UPDATE Customers
  SET CustomerName='john';