:: DEVELOPER ZONE
MySQL Query Browser :: 5.6 Handling BLOB and TEXT Columns
- 5 Using The MySQL Query Browser
- 5.1 Entering and Editing Queries Manually
- 5.2 Building Queries
- 5.3 Creating Views
- 5.4 Navigating Result Sets Within the Result Area
- 5.5 Exporting Result Sets
- 5.6 Handling BLOB and TEXT Columns
- 5.7 Editing Result Sets Within the Result Area
- 5.8 Comparing Result Sets
- 5.9 Creating Master-Detail Views
- 5.10 Managing Stored Procedures and Functions with MySQL Query Browser
- 5.11 Editing Queries From a Development Tool
The MySQL Query Browser provides functionality for dealing with
BLOB and TEXT columns through
a series of special 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 an eye and is used to open the field viewer to view the contents of the field. The field viewer can be used to viewTEXTfields andBLOBfields that contain images.Edit: This field looks like a wrench 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 aTEXTorBLOBfield into a file.Clear: This icon looks like a red X within a red box and is used to clear the contents of aTEXTotBLOBfield.
Only the View and Save icons
are visible is you have not enabled editing for your record set. See
Section 5.7, “Editing Result Sets Within the Result Area” for
information on editing result sets.
© 1995-2005 MySQL AB. All rights reserved.
