6. Edit Data

In Workbench you can view and change data in a table, allowing you to update values, correct mistakes, and more. This part walks you through how to edit table data in Workbench.

Before you continue

Make sure you've already inserted data into your table, and your connection is opened. Refer to Inserting data into tables.

You should be familiar with the contents of the previous sections so you can follow this part easily!

Steps

Changing values

1. Locate the Schemas panel on the left side of the Workbench.

2. Expand your schema and Tables section to locate the table you want to view or edit.

   

3. Right-click that table.

4. Left-click the Select Rows option.

   

   The Result Grid from the last part should show up again.

   

5. Left-click on the cell you want to edit.

   

6. Type in the new value you want.

   

7. Apply the changes you made to the cell the same way you did in the previous parts.

8. Refresh the Result Grid, your table should be edited now.

Deleting data

1. Left-click on the button highlighted in red beside the row you want to delete.

   

2. Right-click the same button to open the menu options for that row.

3. Left-click the Delete Row(s) option in the options menu.

   

   Warning

   Be careful when editing values in a Primary Key column. Primary Keys must remain unique, so changing them may cause errors or affect how rows are identified.

4. Apply the changes the same way you did in the previous parts.

5. Left-click the Refresh button to refresh the Result Grid.

   Success

   The row you deleted should be gone now.

   

Conclusion

You just edited table data in Workbench, you can update existing values and remove unwanted rows. This concludes our beginner's guide, thanks for reading to the end 👍