https://www.sumologic.com/glossary/crud/#:~:text=CRUD Meaning%3A CRUD is an,%2C read%2C update and delete.
CRUD is an acronym that refers to the four functions that are necessary to implement a persistent storage application: create, read, update and delete. Persistent storage refers to any data storage device that retains power after the device is powered off.
A database is simply an organized collection of data that may be viewed electronically. There are many types of databases: hierarchical databases, graph databases, and object-oriented databases to name a few. The most commonly implemented type of database is a relational database, which consists of data tabled in rows and columns and connected to other tables with complementary information by a system of keywords that includes primary keys and foreign keys.
The CRUD acronym identifies all of the major functions that are inherent to relational databases and the applications used to manage them, which include Oracle Database, Microsoft SQL Server, MySQL, and others.
A relational database consists of tables with rows and columns. In a relational database, each row of a table is known as a tuple or a record. Each column of the table represents a specific attribute or field. The four CRUD functions can be called by users to perform different types of operations on selected data within the database.
➕ Create function allows users to create a new record in the database. In the SQL relational database application, the Create function is called INSERT. Remember that a record is a row and that columns are termed attributes. A user can create a new row and populate it with data that corresponds to each attribute, but only an administrator might be able to add new attributes to the table itself.
➕ Read function is similar to a search function. It allows users to search and retrieve specific records in the table and read their values. Users may be able to find desired records using keywords, or by filtering the data based on customized criteria.
➕ Update function is used to modify existing records that exist in the database. To fully change a record, users may have to modify information in multiple fields. As a result, the existing record in the database must be changed and all of the attribute values changed to reflect the characteristics of the new dish.
➕ Delete function allows users to remove records from a database that is no longer needed. Some relational database applications may permit users to perform either a hard delete or a soft delete. A hard delete permanently removes records from the database, while a soft delete might simply update the status of a row to indicate that it has been deleted while leaving the data present and intact.