If you select a MySQL repository in the Repository Tree Panel (LHS), you can see the contents of that repository in the Repository Content Panel (RHS). This content information is lazily loaded—when you expand a node for the first time or refresh it, a request is made to the MySQL server for information, and the results are displayed. Users can view a wide range of information in MySQL, as also shown in Figure 34 below.
Contents of a MySQL repository in the Syndeia Dashboard
For a given MySQL server, users can see all accessible Databases. For a given Database, users can see all the Tables, and for a given Table, users can see all the Table Rows (tuples). Since the tables can be large in a regular MySQL database, users can search for (filter) specific rows by executing a MySQL query from the Syndeia Dashboard, as shown in figure. For example, selecting all rows from the table "cars" in the database "cars" that have Color = 'Red'. To view the latest contents of a table row—it may have changed since you last viewed—right click on the MySQL table and select Refresh. This will reload all the rows in that table.