From Creation to Deletion: MySQL’s Complete Data Toolkit What are CRUD operations? Create, Read, Update, Delete. That’s what we have created over the last few articles. The last piece of the puzzle is to combine them into one file that knows how to manage our authors table. If you’re jumping straight into this article, I recommend that you read the earlier articles leading up to this one first. You don’t need to, but it’ll help. MySQL Introduction MySQL DB Connection MySQL Tables MySQL Insert MySQL Insert with Prepared Statements MySQL Insert Multiple Records with Prepared Statements MySQL Select MySQL Update (PUT vs

Revamping Data with Precision The next logical step in our MySQL progression is updating an existing resource. We’re going to introduce the differences between PUT and PATCH and put it to rest once and for all. It really is a simple concept and I’m not sure why people find it so confusing. PUT vs PATCH Let’s take a look at our authors table. It contains the following fields: id first_name last_name email If we update a resource with the PUT request, we need to send all of the fields. That means that if we update the email, we need to send the id, first_name, last_name, and email. If