Use the Inserts tab to insert records into the table. Clicking the Open Editor ... button on the lower right hand side opens the Standard Inserts editor. Use this editor to add records to the table.

When you have finished adding records, press OK. The records you have added are displayed in the Inserts tab. Reopening the editor displays all the records shown in the Inserts tab. To edit a record simply click on the field you wish to change and enter the new data. To delete a record, click the button on the left beside the desired row and then press the Delete key. You can select and delete all records by clicking in the top left hand column of the editor and then pressing the Delete key. Your changes will not be applied until you press the OK button. To back out of an operation, press the Cancel button.

Any records you add will be inserted when you forward engineer the database (if you choose the Generate INSERT statements for tables option).

Note when entering string values there is slightly different behavior between the 5.0, 5.1 and 5.2 versions of MySQL Workbench.

For 5.0 and 5.1 if a string is entered without leading and trailing quotes, the Inserts Editor adds quoting and escapes characters that require it. However, if quoted text is entered, the Inserts Editor carries out no further checks since it assumes a correctly escaped and quoted sequence has been entered.

5.2 features a new Inserts Editor. In this case the user enters the string without quoting or escaping and the Inserts Editor takes care of all quoting and escaping as required.