Calling MySQL Stored Procedures

How do I call a stored procedure in my MySQL database using SmartConnect?

Once you have connected to your MySQL database using the ODBC Connection type, per this article Connecting to ODBC Datasources, you can use the syntax below.

Call MyStoredProcedure(parameterList);

If you need to find the name of the stored procedure you can use the following command.

SELECT * FROM INFORMATION_SCHEMA.ROUTINES

We recommend reviewing the SQL syntax for MySQL.