Data Management

 Back to the main menu

 In order to view, add, modify, or change data (rows) in your database tables you must either be in the "Content" tab or the "Custom Query" tab.

Adding and editing fields
  • Add or remove entries with the plus- and minus-buttons. You can select more than one entry and remove them together.
  • Edit entries by double-clicking on the value you want to change. If the button with the three lines on it is clicked, double clicking on a value opens a sheet where you can edit it. This is preferred to edit large entries or entries with multiple lines.
  • Use the value specified in the preferences (NULL by default) to enter NULL-values.
  • Changes aren't written to the database until you deselect the row!
  • It is recommended that you edit only tables which have a primary key.


Sorting and filtering the table content
  • To sort a table by a field, click on the header of the appropriate column in the content-view.
  • Click on it twice to sort the table in descending order.
  • Select a field and operator and enter a keyword to filter a table. Click on the Show All-button to disable filtering.
  • As wildcards use % and _ (% matches any number of characters, even zero characters; _ matches exactly one character)
  • If you have selected "Limit result..." in the Preferences, you can specify the first row to be returned and hit "Go".


Binary Data (Images, Strings, Hex Representations)
  • Field type should be Blob or Longblob
  • To edit/enter the data, double select the field in the Content tab
  • Click on Open and load an image
  • Change to image and hex view