MySQL Delete

Settings

The Settings tab has the following field.

Field	Description
Connection	Name of the Oracle MySQL database connection from where information is retrieved. You can select the connection from the Connection dropdown list.

Input Settings

The Input Settings tab has the following field.

Field Description

Delete Statement

Field	Description
Delete Statement	A SQL statement used to delete the record from the table. You can construct prepared SQL queries by using substitution variables (or parameters) of the form `?<fieldname>` in the delete query statement. Each substitution variable identifies an input parameter whose mapped value is substituted into the substitution variable at runtime. Input and Output tabs are populated based on the query. End the query with semicolon (;) to fetch the metadata in the table at the bottom of the query. The following example represents a typical delete query: Delete from advisor where i_id=?i_id; For the above delete query, there is no output field and input field is generated for i_id (VARCHAR). Also, the mapped value for the field name is substituted into the substitution variable ?i_id. Call Procedure and Call Functions Syntax: With no parameters Call Procedure_Name( ); Select Function_Name( ); With prepared parameters Call Procedure_Name(?Param1 , ?Param2); Select Function_Name(?Param1, ?Param2);
Manually Configure Metadata	Set the Manually Configure Metadata field to `True` to fetch table metadata manually. For more information, see Manually Configuring Metadata.
Fields	Displays the database column metadata.

A SQL statement used to delete the record from the table. You can construct prepared SQL queries by using substitution variables (or parameters) of the form ?<fieldname> in the delete query statement.

Each substitution variable identifies an input parameter whose mapped value is substituted into the substitution variable at runtime. Input and Output tabs are populated based on the query.

End the query with semicolon (;) to fetch the metadata in the table at the bottom of the query.

The following example represents a typical delete query:

Delete from advisor where i_id=?i_id;

For the above delete query, there is no output field and input field is generated for i_id (VARCHAR). Also, the mapped value for the field name is substituted into the substitution variable ?i_id.

Call Procedure and Call Functions Syntax:

With no parameters

Call  Procedure_Name( );

Select Function_Name( );

With prepared parameters

Call  Procedure_Name(?Param1 , ?Param2);

Select Function_Name(?Param1, ?Param2);

Manually Configure Metadata

Set the Manually Configure Metadata field to True to fetch table metadata manually. For more information, see Manually Configuring Metadata.

Fields Displays the database column metadata.

Input

This tab displays the input schema of the activity in a tree structure format. The information in the schema varies based on the delete query provided. The fields that are selected on the Input Settings tab are available in the schema. You can either hard code the values or map them to a field from the output of a preceding activity in the flow using the Mapper.

Output

The Delete activity returns the number of rows affected by the query.

Loop

If you want this activity to iterate multiple times within the flow, enter an expression that evaluates the iteration details. Select a type of iteration from the Type menu. The default type is None, which means the activity does not iterate.

Retry on Error

For more information, see the Using the Retry on Error Feature in an Activity section in the Flogo® app documentation.