Skip to content

Bots From Extension: mysql_v2

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

This extension provides 7 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







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







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: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)

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'