MySQL
MySQL is the world’s most popular open source database. With its proven performance, reliability, and ease-of-use, MySQL has become the leading database choice for web-based applications.
Integration with LogicHub
Connecting with MySQL
To connect to MySQL following details are required:
- Label: Connection name.
- Reference Values: Define variables here to templatize integration connections and actions. For example, you can use https://www.{{hostname}}.com where, hostname is a variable defined in this input. For more information on how to add data, see 'Add Data' Input Type for Integrations.
- Server Name or Hostname of Database: Example: 192.168.1.1 or mydatabase.example.com.
- Port (Optional): Specify the port on which database server is listening, default is 3306.
- Schema/Database Name (Optional): Specify default database to connect.
- Username: Username for connecting to the database.
- Password: Password for connecting to the database.
Actions with MySQL
Query
Query MySQL Database.
Inputs to this Action
- Connection: Choose connection that you have created.
- Query Template: Jinja2 Template, following are some examples:
Select ID, name from customers where city_id = {{city_id_column_name}}
{{query_column_name}}
Select ID, date, amount from orders
Update customers set name = ‘new name’ where id = 3
Here variables inside curly braces {{}} refer to the column of the parent node’s results table.
Output of Action
If the query returns results, for example, select * from orders, the following will be the one row of the output.


In case the query does not return results, for example, update customers set name = ‘new name’ where id = 3. The output will be as follows:


Updated about 1 year ago
Did this page help you?