MySQL – Update Column Value for All Entries in Table
To update values of a column for all records in a table in MySQL, use SQL UPDATE statement.
In this tutorial, we will learn the syntax of SQL UPDATE statement, and how to use it to update a field/column for all rows in the table, with examples.
The following is a simple syntax of UPDATE statement to update a column value for all entries.
UPDATE table_name SET column_name = new_value;
- table_name is the table name in which we would like to update.
- column_name is the name of column whose value for all the rows in the table has to be updated.
- new_value will be assigned to the specified column for all rows in table.
In the following example, we will consider a table
students and update the column
-1 for all the entries.
UPDATE students SET rollno = -1;
“students” table before UPDATE
name rollno Arjun 14 Manish 15 Vina 16
“students” table after UPDATE
name rollno Arjun -1 Manish -1 Vina -1