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/ navigate to connections page by clicking on the connections on the left side bar or by clicking 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 “add connection” form 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 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 fields choose the fields you want to populate in the table each field should correspond to a column in the database 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 option to filter records using specific conditions add sorting option to sort the records based on specific fields 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 option to add fields that need to be updated in the selected record update records table choose the table where the records to be updated are located add fields option to add more fields that need to be updated add filter option to add more filters to refine the record selection keep connection alive until complete keeps the connection open until the update process is fully completed delete records table choose the table from which records will be deleted filter select the fields and conditions to filter the records that should be deleted you can add multiple filters with “and” conditions to refine the deletion criteria keep connection alive until complete ensures that the connection remains open until the deletion process is finished 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 keep connection alive until complete ensures the connection remains active during the entire batch insert process, especially for large datasets 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 sorting option to sort the records based on specific fields add filter apply filters to narrow down the records being retrieved keep connection alive until complete keeps the connection open until the entire batch process is completed 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 option to apply filters to narrow down which records should be updated keep connection alive until complete ensures the connection remains open until the batch update process is fully completed 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) keep connection alive until complete ensures the connection remains open while the query is being executed, particularly useful for long running queries or complex operations 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 keep connection alive until complete ensures that the connection remains active while the procedure is being executed, useful for procedures that take time to complete