Fill in the Blanks CRUD - operationsOnline version programming by Arturo Castillo 1 How CRUD Works : Executing Operations and Examples Based on the requirements of a system , varying user may have different CRUD cycles . A customer may use to create an and access that account when returning to a particular site . The user may then update personal data or change billing information . On the other hand , an operations manager might create product records , then call them when needed or modify line items . During the Web 2 . 0 era , CRUD operations were at the foundation of most dynamic websites . However , you should differentiate CRUD from the HTTP action verbs . For example , if you want to create a new record you should use " POST . " To update a record , you would use " PUT " or " PATCH . " If you wanted to delete a record , you would use " DELETE . " Through CRUD , users and administrators had the access rights to edit , delete , create or online records . An application designer has many options for executing CRUD operations . One of the most efficient of choices is to a set of stored procedures in SQL to execute operations . With regard to CRUD stored , here are a few common naming conventions : The procedure name should end with the implemented name of the CRUD operation . The should not be the same as the prefix used for other user - defined stored procedures . CRUD procedures for the same will be grouped together if you use the table name after the prefix . After adding CRUD procedures , you can update the database by identifying the database entity where CRUD operations will be implemented .
New game