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.
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.
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.