Menu

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.








Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe