# Modifying Data

In the previous chapter we looked at various ways to query data from a database. Now we will look at how to insert new records into a database, how to update existing records and also how to delete records.

Updated: November 16, 2026

## [Modifying Data](https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/modifying-data)

1. [Inserting Data](https://www.ask-codey.com/lessons/modifying-data-inserting-data) (Apprentice): Add rows to a table with INSERT, for every column or only some, one row or several at once, without breaking a foreign key.

## [Updating Data](https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/updating-data)

1. [ANSI Standard Syntax for UPDATE](https://www.ask-codey.com/lessons/updating-data-ansi-standard-syntax-for-update) (Apprentice): Change existing rows with UPDATE ... SET, and always limit it with a WHERE clause you've checked with a SELECT first.

## [Deleting Data](https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/deleting-data)

1. [ANSI Standard Syntax for DELETE](https://www.ask-codey.com/lessons/deleting-data-ansi-standard-syntax-for-delete) (Apprentice): Remove rows with DELETE FROM, always limited by a WHERE clause you've checked with a SELECT first.

Source: https://www.ask-codey.com/courses/java-full-stack-bootcamp/chapters/modifying-data
