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 (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
Last updated