Skip navigation links
MySQL Query Browser :: 9 Using The MySQL Query Browser :: 9.6 Handling BLOB and TEXT Columns
9.7 Editing Result Sets Within the Result Area »
Section Navigation      [Toggle]

9.6. Handling BLOB and TEXT Columns

The MySQL Query Browser provides functionality for dealing with BLOB and TEXT columns through a series of special icons.

Figure 9.2. The BLOB Handling Icons

The BLOB handling icons

These icons appear in any BLOB or TEXT columns in your result set. From left to right the following icons are available:

  • Open File: This icon looks like a file folder and is used to open a file for loading into the field.

  • View: This icon looks like a magnifying glass and is used to open the field viewer to view the contents of the field. The field viewer can be used to view TEXT fields and BLOB fields that contain images.

  • Edit: This icon looks like a pencil and opens the field viewer in edit mode, allowing you to make changes to the data and apply the changes to the result set.

  • Save: This icon looks like a floppy disk and is used to save the contents of a TEXT or BLOB field into a file.

  • Clear: This icon looks like an X within a black box and is used to clear the contents of a TEXT or BLOB field.

Only the View and Save icons are visible if you have not enabled edit mode. See Section 9.7, “Editing Result Sets Within the Result Area” for information on editing result sets.

The functionality represented by the icons is also available by right-clicking on the field. The blob handling icons can be displayed and hidden through the display options. See Section 11.5.1, “Display Options” for more information.