> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/build/mysql.md).

# 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

1. Create a mySql credential.
2. Search for MySQL, connect it after the previous node, and select that credential.
3. Leave Operation on Insert.
4. Choose Table.
5. 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](/build/postgres.md) and [Find documents with MongoDB in Duaer](/build/mongodb.md).
## 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.

## Related

- [Read and write Postgres in Duaer](https://doc.duaer.com/build/postgres.md)
- [Find documents with MongoDB in Duaer](https://doc.duaer.com/build/mongodb.md)
- [Keep rows in a Duaer data table](https://doc.duaer.com/build/data-tables.md)