Using WinMySQL Professional

Upload blob

Only accessible when connected and a table is active and when the grid is switched to table editor mode (to be sure, perform a «Table management>Reload» with «Ctrl-Z»), the «Record>Upload blob» submenu allows a user to upload any file into a column.

Blobs are often used to store multimedia file such as sounds or photos. Because of a MySQL® limitation, a table can't exceed 4Gbytes on the robustest OS such as Sun® Solaris® and 2Gbytes on the others ; so, inserting blobs when the filesizes are enormous is not really a good idea!

How to upload a blob ?

To send a blob into the current table, first, be sure that the grid is switched in table editor mode, put the cursor on the record field which must receive the blob. Invoke the «Record>Upload blob» submenu clicking on it or using the «Ctrl-U» shortcut. A file open screen then displays to ask you the filename of the entity to upload.

If you intent to upload a blob into an incompatible column, WinMySQL Professional will tell you but if you intent to upload a blob into a compatible column (such as varchar, text ...) but undersized, WinMySQL Professional will let do it but the MySQL® server will truncate it.

Because of the RowID mechanism not yet supported by MySQL®, if the table doesn't have any primary key, it is possible that several identical lines may be affected. If the table is in this case, WinMySQL Professional will notity if the «Record>No primary key warning» submenu is unchecked.