MySQL

learn how to seamlessly connect mysql to engini, enabling efficient database integration for your workflows with the mysql connector, you can manage data, run queries, and automate database interactions directly in engini enhance productivity by integrating mysql’s powerful capabilities into your business processes getting started with mysql prerequisites a mysql account this includes the username and password to access the database connecting engini to mysql enter your engini account at https //app engini io https //app engini io/ navigate to connections page by clicking on the connections on the left side bar or by clicking here https //app engini io/connections click on the "new integration" option located at the top bar choose mysql option from available applications enter the following details in the “new integration” form and press save connection name choose a name for easy reference to this connection server address the ip address or domain where the mysql server is hosted database name the name of the specific mysql database you want to connect to username the mysql username with sufficient access rights password the corresponding password for the mysql username communication channel ensure the communication channel (likely cloud) is accessible for remote connection save settings click on the save button located at the bottom of the form actions specific tasks you want to perform in your mysql database through engini these actions can automate data management, such as inserting records, running queries, or interacting with specific tables and databases in mysql create record table choose the table where the new record will be inserted make sure to select the correct table from your database add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields get records table/view choose the table or view from which you want to retrieve records top specify the total number of rows to retrieve (default is 100) offset define the number of rows to skip before retrieving records (default is 0) add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add sort click add sort to organize the data list by a selected field in ascending or descending order to learn more about sorting data, click here https //help engini ai/workflow editor#add sorts update record table choose the table where the record to be updated is located accountid (pk) input the primary key (accountid) for identifying the specific record to be updated add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields update records table choose the table where the records to be updated are located add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields delete records table choose the table from which records will be deleted add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters create batch of records data list specifies the list of records you want to insert the batch can handle up to 1000 items table the name of the table where the records will be inserted add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields get records batch data list provide the data list for the batch operation (maximum batch size is 1000 items) table choose the table from which to retrieve the batch of records top specify the number of rows to retrieve (default is 100) add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add sort click add sort to organize the data list by a selected field in ascending or descending order to learn more about sorting data, click here https //help engini ai/workflow editor#add sorts update batch of records data list provide the list of records to be updated in the batch (maximum size is 1000 items) table choose the table where the records will be updated add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields execute customized sql sql input your custom sql query to be executed on the connected mysql database you can use this action to run any valid sql command (e g , select, update, delete) execute procedure procedure name input the name of the stored procedure you want to execute on the mysql database this action allows you to run predefined procedures that handle specific tasks or logic within your database