How to change values of a column in all rows?

Here is the syntax for the statement used to change all values of a table column to a new value:

UPDATE table_name SET column_name = value;

To update multiple columns:

UPDATE table_name SET column_name1 = value_1, column_name2 = value_2;

Example:

UPDATE users SET default_password = 'Str0ngp@ssw0rd';

This will change all current values of the column default_password to Str0ngp@ssw0rd.

Change multiple values via TablePlus GUI

In TablePlus, you can change multiple values of a column using the right toggle from the GUI.

• Select all the rows you need to make changes
• If the right toggle is not enabled yet, press Space to open it.
• Enter the new value for the column you need to make changes.
• Hit Cmd + S to commit the changes to the server. Before you commit, all changes will be pending and you can preview the SQL code by clicking on the eye button at the top left panel.

---

Need a good GUI tool for databases? TablePlus provides a native client that allows you to access and manage Oracle, MySQL, SQL Server, PostgreSQL, and many other databases simultaneously using an intuitive and powerful graphical interface.

Download TablePlus for Mac.

Not on Mac? Download TablePlus for Windows.

On Linux? Download TablePlus for Linux

Need a quick edit on the go? Download TablePlus for iOS