Making life easier - Database Design Manual: Using MySQL for Windows - page 194

Figure 16.1 The main MySQL Control Centre screen.

Figure 16.2 A table's context menu.

Below the list of column names are the properties for the object selected. In the figure we
have just selected the Table Properties. This outlines the attributes of the table and even
allows you to change table types from a dropdown list. Each individual column has proper-
ties that you can also change if required.
Under these options is a status window that gives you any messages that the MySQL
server sends while you are navigating your database.
Figure 16.4 shows the screen you are taken to if you select one of the Open Table options
from the context menu. This time you have a screen that shows the results of the query. In
the figure, we have just pressed the SQL button which has opened a window that contains
the select query that the Control Centre used to generate the results set. A WHERE clause
was then added to the select statement and the Execute Query button (the exclamation