# 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: 91b5ea3b95a0824bcd0e0d61f68d6121c6e45039fde2b5f874c4c65eec29030e Source revision: b6716699f6439c3ba6ae3bf7116b7da84963c978 ## 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)