When dbForge Documenter for MySQL executes any statement returning a result set, the retrieved data is displayed in the Data Editor of the data view of the same SQL document. This topic shows how to edit the data in grid.
Use the shortcut menu or the corresponding buttons under the grid. For example, you can do the following:
To insert NULL (instead of empty string), select Set Value To, Null on the shortcut menu. You can also use the CTRL+0 key combination.
Tip: Use the Set Value To menu to quickly set an empty string, zero, or a current date.
To insert SET and ENUM data, Documenter for MySQL offers convenient editors. Click a field of ENUM data type and select a required value from the drop-down list.
Click a field of SET data type and tick off a required value (or values) in the drop-down editor.
To add a new record, select the Append option on the shortcut menu, or click the Append button under the grid. To delete a record from the grid, select the Delete option on the shortcut menu or click the - button under the grid, or press CTRL+DEL keys.
To copy and paste cell values, use the corresponding options on the shortcut menu.
You can easily select and copy the data just like cells in a spreadsheet. Do either of these actions:
Tip: Using the CTRL key, you may include and exclude cells to selection. Any number of rows may be copied and pasted to some other application, for example, a spreadsheet, but when you paste data in data grid, only the first row will be pasted.
Actual document look may slightly vary from the above image depending on the product you use.
Some queries return read only data, for example, queries with aggregate functions (count, avg etc.), or data, retrieved from non-updatable views. Such data can’t be edited. It is also impossible to edit the result of executing of the script with several select statements.
When working with grid, you can see special indicators near to the focused cell. These indicators reflect current editing state.
The row is focused.
The row has been edited.
Incorrect value was entered into a cell. You must either fix the value or press the ESCAPE key to cancel changes made to the cell.