MySQL Query

MySQL Query block

Description

This block allows you to run a MySQL query

Properties

Connection String

Takes a query string of the required connection parameters as shown below. This can be a string or a variable.

host=127.0.0.1&user=auser&password=pass

• host (string, host IP address)

• username (string, username of database connection)

• password

• database

• port

• flags (check npm documentation)

• charset

• timezone

• connectTimeout

• ssl_ca - Add a ssl certificate path

• insecureAuth

SQL Query

The query that needs to be executed. This can be a string or variable.

Returns (Array of objects)

Returns an array of objects or an empty array

NPM Package

The MySQL block uses this package to run its queries.

Package Name: mysql

Link: https://www.npmjs.com/package/mysql

Version: 2.18.1

Learn more about the connection options - https://www.npmjs.com/package/mysql