# Inserting and modifying data

> Part of Prisma's Data Guide. The complete index is at https://www.prisma.io/dataguide/llms.txt.

Inserting and modifying data in MySQL. Including how to insert and delete data in MySQL, update existing data in MySQL, and more.

Canonical URL: https://www.prisma.io/dataguide/mysql/inserting-and-modifying-data
Content revision: 9607eba7863fd2457b443a020cc46fc14e4dd6ad8d0c5b91f0175c4e26f009dc
Source revision: 966174084131f9cfdc77eefcb4db38af72c1a29d

## In this section

- [How to insert and delete data in MySQL](https://www.prisma.io/dataguide/mysql/inserting-and-modifying-data/inserting-and-deleting-data.md)
- [How to update existing data in MySQL](https://www.prisma.io/dataguide/mysql/inserting-and-modifying-data/updating-existing-data.md)
- [How to use \`ON DUPLICATE KEY UPDATE\` to upsert data in MySQL](https://www.prisma.io/dataguide/mysql/inserting-and-modifying-data/insert-on-duplicate-key-update.md)
- [Importing and exporting data in MySQL](https://www.prisma.io/dataguide/mysql/inserting-and-modifying-data/importing-and-exporting-data-in-mysql.md)
- [Understanding and using transactions in MySQL](https://www.prisma.io/dataguide/mysql/inserting-and-modifying-data/using-transactions.md)