Data Editing

Of course Database Workbench has tools to view and edit data in your database.

There's also the possibility to quickly print data, as well as complex data reporting.

View and Edit Data

The Table and View Editor contain a Data-tab that will show the data for the selected table or view. You can edit the data directly, different data types like date/time can have special editors attached.

Sorting data is as easy as clicking the header and you can filter the data by entering one or more values in the filter bar.

You can select any data in the SQL Editor, sort and filter the result set and add additional data grouping.

BLOB Editor

Binary Large Objects (BLOBs) can be used to store large pieces of text, documents, images and video. The Database Workbench BLOB Editor is used to view and edit such data. You can load files to put those into the database, or save existing binary data into files.

The best thing about the BLOB Editor is that it will automatically recognized the type of data in the database: it will recognize several image types, or recognize PDF, HTML and Document data.

  • View and edit binary data as hex values
  • View and edit large text, with support for Unicode
  • Automatically recognize images of the following types: bmp, eps, gif, ico, jpg, pcx, psp, psd, png, sgi, tga and tif
  • View the following documents: html, asp, php, pdf, doc, docx, rtf and xml

Print query data

Use the print button in the SQL Editor, or Table and View Editor to quickly print any result set.

In addition to printing query results, you can design complex reports yourself.