User manual MYSQL MAESTRO

[. . . ] MySQL Maestro User's guide Copyright © 2002-2009 SQL Maestro Group I MySQL Maestro Help Table of Contents Foreword 0 I Welcome to MySQL Maestro! 1 Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Registration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 License Agreement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 System. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ] Partition type (since MySQL 5. 1. x) © 2009 SQL Maestro Group 110 MySQL Maestro Help The field displays the type of current table partitioning type. For more information see Specifying table options 101 . Auto increment (only to integer types) Specify a special counter called the auto-increment counter that is used in assigning new values for the column. With MySQL Maestro you can also analyse, check, repair and optimize your tables. Just use the appropriate link at Navigation bar. MySQL Maestro allows you to reorder columns for existing tables. To open the Reorder fields window, use the appropriate link of the popup menu or at the Navigation bar. To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl +F9 or Ctrl+F7 shortcut keys. It is also possible to modify object properties without opening the object editor: use the © 2009 SQL Maestro Group Database Object Management 111 Object Properties item of the popup menu of the selected object from the explorer tree. 4. 2. 2. 2 Managing table data The Data tab displays the table data as a grid (see Data View 210 for details). Use grid's popup menu to open Data Input Form, to invoke the Export Data, Import Data and Get SQL Dump modules, to set the value of the selected record to NULL or to Now (for Date values). The data grid also provides you with a possibility of displaying data in the master-detail form (multiple detail pages can be displayed for a single master row). Use the Show/Hide details link at the editor's navigation bar to activate/deactivate this view mode. In case the table contains BLOB columns you can also run BLOB Editor edit the content of these fields. MySQL Maestro allows you to adjust 306 224 to view and numbering columns in grids. © 2009 SQL Maestro Group 112 MySQL Maestro Help Along with data grid MySQL Maestro provides you with possibility of viewing data as info cards. © 2009 SQL Maestro Group Database Object Management 113 4. 2. 3 Fields Table Columns are created and edited in MySQL Maestro within the Field Editor. The topics below describe each of these actions in detail. Table fields are created within the Field Editor order to open the dialog you should either 113 dialog window. In · open the table in Table Editor and the Fields tab there; · press the Insert key or select the Add New Field. . . item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar) or · select the table in the explorer tree and use the Create New Field popup menu item or © 2009 SQL Maestro Group 114 MySQL Maestro Help · select the table Fields node or any field within the table in the explorer tree and use the Add New Field. . . popup menu item. How to edit an existing table field?Table fields are edited within the Field Editor order to open the dialog you should either 113 dialog window. In · open the table in Table Editor and the Fields tab there; · press the Enter key or select the Edit Field item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar) or · select the field to edit in the explorer tree and use the Edit Field popup menu item. You can change the name of the field using the Rename Field dialog. [. . . ] This will add a new condition to the criteria. Alternatively, you can use the Filter button and select the Add Condition option from the drop-down menu. 10. 1. 2 Setting filter criteria Since we need to apply the filter criteria to the SaleDate column, we select the column name box to open the drop-down list displaying the available column names. Then we are to select the SaleDate item. © 2009 SQL Maestro Group Appendix 335 10. 1. 3 Setting filter operator Select the BETWEEN item in the operator box (next to the column name box). This will add two empty value boxes to specify the inclusive range for the BETWEEN condition. © 2009 SQL Maestro Group 336 MySQL Maestro Help 10. 1. 4 Setting filter criteria values Next, you need to specify the range for the BETWEEN operator. [. . . ]