Skip to content

Bots From Extension: mysql_v2

MySQL - Read, Write and Update tables in MySQL / MariaDB

This extension provides 8 bots.





Bot @mysqlv2:append

Bot Position In Pipeline: Sink

MySQL - add a new record to an existing database table

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
dbname* Text Database Name
table* Text Table Name
retry_count Text 0 Number of times to retry on failure.
retry_interval Text 10 Seconds to wait before retrying on failure.







Bot @mysqlv2:create-table

Bot Position In Pipeline: Sink

MySQL - create tables

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
dbname* Text Database name
table_name* Text Table name
retry_count Text 0 Number of times to retry on failure.
retry_interval Text 10 Seconds to wait before retrying on failure.







Bot @mysqlv2:delete

Bot Position In Pipeline: Sink

MySQL - delete records from database table

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
dbname* Text Database Name
table* Text Database table name
delete_query Text where clause - query for deleting rows in table







Bot @mysqlv2:list-dbtables

Bot Position In Pipeline: Source

MySQL - get database tables

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
dbname Text Database Name







Bot @mysqlv2:meta

Bot Position In Pipeline: Source

MySQL - get database table schema

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
dbname* Text Database Name
table* Text Table Name







Bot @mysqlv2:native-query

Bot Position In Pipeline: Source Sink

MySQL - Run native SQL query on the Database.

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
dbname* Text Specify a Database name
query* Text Enter native MYSQL query to create,
charset_type Text latin1 Specify charset type,default type will be 'latin1'
_skip_errors Text no Specify 'yes' or 'no'. If 'yes', do not bailout if the query results in error.
retry_count Text 0 Number of times to retry on failure.
retry_interval Text 10 Seconds to wait before retrying on failure.







Bot #mysqlv2:read

Bot Position In Pipeline: Sink

MySQL - query the data from a database table. Expects 'table' and 'dbname' columns from input dataset; Optional 'limit' can also be provided (default 1000); Optional 'charset_type' can also be provided (default latin1)

This bot expects Full CFXQL.

Bot translates the Query to native query of the Data source supported by this extension.







Bot @mysqlv2:update

Bot Position In Pipeline: Sink

MySQL - update an existing record within a database table

This bot expects a Restricted CFXQL.

Each parameter may be specified using '=' operator and AND logical operation
Following are the parameters expected for this Bot

Parameter Name Type Default Value Description
dbname* Text Database Name
table* Text Table Name
replace_record Text yes Specify yes/no to replace/update existing record
update_columns Text Specify comma separated columns that has to update, by default all the columns will be updated
charset_type Text utf8 Specify charset type,default type will be 'utf8'
retry_count Text 0 Number of times to retry on failure.
retry_interval Text 10 Seconds to wait before retrying on failure.