Figure 43-6:A quick view (Sri lanka web server) of the fields within

Figure 43-6:A quick view of the fields within a table. Figure 43-7:Table data displayed with the Control Center. The Databases controls include some handy tools tohelp you manage and repair your MySQL database: 1.Highlight Tables in the tree control and thenchoose Action.Tools to open the drop-downmenu (see Figure 43-8). 2.Choose an option from the Tools menu. Hereare your choices: 1.Follow the steps in the section, AccessingMySQL Control Center features, earlier in thistechnique, to access the controls. 2.Highlight the Databases entry, as shown inFigure 43-5. Figure 43-5:The Databases statistics. 3.Click the tree control next to the Databasesfolder to display the databases on the server. 4.Click the tree control next to the Tables entryto view the tables in the database. 5.Highlight a table name to view the fields withinthat table (see Figure 43-6). 6.Double-click the table name to see the datawithin that table. The table data is displayed, as shown inFigure43-7. You can adjust the number of rows displayed, but by default, MySQLCC displays the first1,000 rows. To adjust the default row limit, highlight the server (in the left-most pane), click the Edit button (in the toolbar), thenchoose MySQL Options and type a row countinto the limit field.
Go visit our java server pages services for a reliable, lowcost webhost to satisfy all your needs.

Leave a Reply