Calling MySQL functions

It is possible to call MySQL functions using passthrough queries. This can help to generate results without having to write additional code. To do this, you simply need to create a passthrough query and use it to call functions as you would in MySQL.

Exercise 10.02 – Passthrough (calling MySQL functions)

You would like to be able to count the values in the series table in order to use the values in analytics for reporting purposes. You currently have a function to do this, called fnCountSeries. To be able to count the values, you can call this function from Access. The following steps will demonstrate how this is done:

1. We are working on SQL 5, the Series count. Locate the code in MS Access.
2. Load the Create Function fnCountSeries.sql file into a query tab in Workbench and run it. This will create a function to count and return the records in the series table, as illustrated in the following screenshot. Verify the function that was created...