Text, Decimal, Integer, Boolean, DateTime, CollectionĪdds a parametrized query execution. Do not use single quotations instead, for parametrized queries, add query parameter key names and values. The concatenated queries, separated by semicolons, that will run on your database. ![]() ![]() The MySQL connection to use for the query. Click Add SQL query parameters to add more parameter names and values.Ĭonnection Credentials and other settings required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.To add a parametrized query execution, in Query parameters, click Add SQL query parameters.SQL script example: SELECT * FROM įor more guidance on SQL keywords and syntax, see SQL Keywords Reference. Do not use single quotations instead, for parametrized queries, add query parameter key names and values (next step). In SQL script, type concatenated queries, separated by semicolons, to run on your database.For more information on source IP addresses you can use, see Source IP addresses for workflows. If you do not have a connection, see Add a connection on the Connections page.Ĭaution: Make sure to first configure your database's firewall to allow your workflow to connect to your database. ![]() Click the MySQL - Execute a query action.Drag the MySQL - Execute a query action to the point in the workflow when you want to run a query.MySQL - Execute a query fields and settingsĬlick the MySQL action group in the action toolbox.įind actions by browsing action groups, or by typing an action name or function in the Search field at the top of the action toolbox. Learn about Handling files in your workflowĬonfigure the MySQL - Execute a query action
0 Comments
Leave a Reply. |