SQL Oracle PHP Java JSP JDBC MORE

SQL query for UPDATE table data


To update existing records in a table UPDATE statement is used.

SQL UPDATE Syntax

UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;

The WHERE clause specifies which record or records that should be updated. If you not write the WHERE clause query, all records will be updated.