MySQL Bugs: #5381: Ability to Clear BLOBs in Control Center

Bug #5381	Ability to Clear BLOBs in Control Center
Submitted:	3 Sep 2004 4:26	Modified:	4 Aug 2005 22:51
Reporter:	Robert Follett	Email Updates:
Status:	Won't fix	Impact on me:	None
Category:	MySQLCC	Severity:	S4 (Feature request)
Version:	0.9.4-beta	OS:	Windows (Microsoft Windows NT 5.1 SP2)
Assigned to:		CPU Architecture:	Any

Description:
MySQL Control Center has a special function for handling images in a BLOB field. You can load and view the images themselves rather than the garbage string that represents them in the BLOB. However, we are unable to *clear* the BLOB field to contain "" (empty string) or NULL. Essentially, using only MySQLCC means you can load BLOBs in but never remove them without removing the entire row.

How to repeat:
Using MySQL Control Center, create a table containing a BLOB datatype field. Insert a row into that table and use MySQLCC to add an image into the BLOB field, and save the table. You are unable to remove that image you just loaded without dropping the entire row.

Suggested fix:
Add a button that causes the BLOB field to clear. (After a confirmation prompt for safety, of course)

Example of Current MySQLCC BLOB Features

Attachment: mysqlcc-bugreport-02092004.jpg (image/pjpeg, text), 97.18 KiB.

Upgraded feature request priority to "High" due to concurrance of severity by colleagues using MySQLCC.

Thank you for your interest in the MySQL graphical administration tools.
We recommend that you use our MySQL Administrator and MySQL Query
Browser.  The MySQLGUI and MySQL Command Center legacy products are
deprecated, and we are no longer maintaining those projects.

For more information on MySQL Administrator, see:
http://www.mysql.com/products/administrator/