Build
Read and write MySQL in Duaer
In Duaer, MySQL defaults to Operation Insert. Choose Table. Data Mode defaults to Auto-Map Input Data to Columns. You need a mySql credential.
Insert a row
- Create a mySql credential.
- Search for MySQL, connect it after the previous node, and select that credential.
- Leave Operation on Insert.
- Choose Table.
- Leave Data Mode on Auto-Map Input Data to Columns (input field names must match column names). Select Execute step.
Data Mode can also be Map Each Column Manually.
Other operations: Select, Update, Insert or Update, Delete, and Execute SQL for raw SQL. The panel label is Execute SQL, not Execute Query.
See also Read and write Postgres in Duaer and Find documents with MongoDB in Duaer.
Questions
Are MySQL and Postgres operations named the same in Duaer?
They are similar, but raw SQL is labeled Execute SQL on MySQL and Execute Query on Postgres.
In this section
Read and write Postgres in Duaer
In Duaer, Postgres defaults to Operation Insert. Choose Schema and Table, then map fields in Columns. You need a postgres credential.
NodesFind documents with MongoDB in Duaer
In Duaer, MongoDB defaults to Resource Document and Operation Find. Set Collection. Query (JSON Format) defaults to {}. You need a mongoDb credential.
DataKeep rows in a Duaer data table
In Duaer, a data table lives in the current project. Rows one digital organization writes can be read by another in the same project.