Query execution using data records from a MySQL data baseΒΆ

Highlight another query from family_db.flr, for example, the TestMan query, and press Execute. The query uses the MySQL connection established by OpenDB, retrieves records from the table men, and produces a list of results as shown in Fig. 270.

A list of men from MySQL data base: **floradb**

Fig. 270 A list of men from MySQL data base: floradb

You can verify these results with a terminal MySQL interface. For example, in a command tool window on Windows, or a terminal window on the Mac, launch the MySQL interface by typing:

Path-to-your-MySQL-installation/bin/mysql -u florauser -pflorapass

Then at the MySQL prompt, type:

use floradb;
select * from men;

and you should see the same 2 records in the men table, as shown in Fig. 271.

Records from the MySQL **men** table

Fig. 271 Records from the MySQL men table

Highlight the query TestBirthdate and press Execute. This query retrieves records from 2 MySQL tables: men and women, and produces a combined list of all birthdates, as shown in Fig. 272.

Results for query TestBirthdate

Fig. 272 Results for query TestBirthdate