CRUD

CRUD is an acronym that describes the four basic ways applications work with stored data: CREATE, READ, UPDATE, and DELETE. These four operations are the bread and butter of nearly every database and map directly to a lot of real-world application functionality:

• CREATE: sign up a new user, post a comment
• READ: load a user's profile, view a list of products
• UPDATE: edit a comment, change your password
• DELETE: remove a post, close an account

Assignment

We've created a table for you called crud, it's a toy table we're using for interview practice at CashPal.

Determine which SQL command can be used for a READ operation and use it to read all the fields in all the records in the crud table!

Hint

Reading data is just another way of saying retrieving data.