Browse and edit database tables

All the rules described in the topic Edit a structure are also true for browsing and editing database tables. The window used to work with database tables, contains the following extra controls:

• Paging controls. The list can consist more than one page. One page can contain up to 20 rows.
• Buttons to add and delete rows.
• Edit box to enter a selection condition. The final set will contain only the rows matching given condition. The condition syntax is consistent with the condition syntax following the WHERE clause of the SELECT command in SQL language (for example NAME = ‘Test’ or VALUE < 32.5). 
• Edit box to enter a sort condition. The selected rows will be sorted according to given condition. The condition syntax is consistent with the condition syntax following the ORDER BY clause of the SELECT command in SQL language (for example NAME – in descending order according to the NAME column or VALUE DESC – in descending order according to VALUE column). Clicking the Refresh button after entering a condition is necessary to execute corresponding selection.
• Button - History, it keeps 10 last conditions WHERE.

Note: For MySQL database, the action optimally works when paging through the next page. To access to the previous page, you must start from the beginning.