Macromedia Dreamweaver 8 UNLEASHED [Electronic resources] نسخه متنی

1.

Open a browser and navigate to http://www.sqlmaestro.com/products/maestro/downloa214.

2.

Click the Download button for the MySQL Maestro executable file. You are prompted to save the file to your computer. Do so now.

3.

Locate the ZIP package on your computer and extract the MyMaestro.exe file from it.

1.

Double-click the MyMaestro.exe file to open MySQL Maestro.

2.

Select the Manage Existing Database option from the Getting Started menu. The Create Database Profiles Wizard appears.

3.

Enter your Host name, User name, and Password in the text boxes provided and click Next similar to Figure 24.8.

4.

Choose the Dorknozzle database from the Available Databases list and click the single-arrow icon to move the Dorknozzle database over to the Selected Databases list similar to Figure 24.9. Click Next.

5.

Click Ready to begin managing your database.

1.

Right-click the Dorknozzle instance in the database list and choose Connect to Database similar to Figure 24.10. A connection to the Dorknozzle database is established.

2.

To work with the Query Builder, right-click the Dorknozzle database option in the database list and choose the Visual Query Builder option from the Database Tools submenu, similar to Figure 24.11. The Query Builder opens with the Diagram tab selected.

3.

To begin building a visual query, right-click the Diagram window and choose the Add Table(s) option similar to Figure 24.12. The Add Tables dialog appears.

4.

Select both the CreditCards and Employees tables from the Add Tables list and click OK. The two tables are added to the diagram.

5.

To create a query that joins the Employees table and the CreditCards table based on their EmployeeID fields, we must first establish a relationship between the EmployeeID primary key in the Employees table and the EmployeeID foreign key in the CreditCards table. To do this, simply click, hold, and drag the EmployeeID field from the Employees table into the EmployeeID field in the CreditCards table. As you can see from Figure 24.13, a line is added to the diagram that represents the relationship between the two tables.

6.

Choose the fields (by clicking the check boxes) you want to include in the query. When finished, the result appears similar to Figure 24.14.