MySQL Node

This node belongs to the Storage Nodes category and will allow you basic access to a MySQL database.

Through the query operation, on the configured database, it enables both the insertion and deletion of data and SQL injection.

  In the video below, learn about the properties of the node:

 Download the example flow at this Link.

Below you will find the definition of each field to complete when configuring the node:

1. Name: optional field where you can write a custom name for the node, which will be visible from the Studio workspace.
2. Database:will allow you to select a database that you have already configured or add a new one, from the editing pencil.
   1. Name: name of the table to use, within the database.  
   2. Host: defines the location of your MySQL server and database.
   3. Port: is the interface through which different types of data can be sent and received. Commonly, the number 3306 is used.
   4. User: user ID of the account designated to enter the database. 
   5. Password: you will fill in the password used to connect to the database. 
   6. Database: here you will indicate the name of the table to which you need to connect from Studio.
   7. Time Zone: non-mandatory field that allows you to change the date format.
   8. Charset: non-mandatory field that defines the set of characters that can be stored in the database. MySQL supports a wide variety, such as UTF-8 and Latin1, among others.

Key fact: a Function node must be placed before MySQL, in order to load the Query that needs to be used depending on the case.