{"id":10935,"date":"2023-03-16T15:07:00","date_gmt":"2023-03-16T15:07:00","guid":{"rendered":"https:\/\/stackify.com\/?p=10935"},"modified":"2024-04-18T04:34:41","modified_gmt":"2024-04-18T04:34:41","slug":"what-are-crud-operations","status":"publish","type":"post","link":"https:\/\/stackify.com\/what-are-crud-operations\/","title":{"rendered":"What are CRUD Operations: How CRUD Operations Work, Examples, Tutorials &#038; More"},"content":{"rendered":"\n<p>If you&#8217;ve ever worked with a database, you&#8217;ve likely worked with CRUD operations. CRUD operations are often used with SQL, a topic we&#8217;ve covered in depth (see <a href=\"https:\/\/stackify.com\/view-sql-with-prefix\/\">this article<\/a>, <a href=\"https:\/\/stackify.com\/measure-real-world-sql-performance-asp-net\/\">this one<\/a>, and <a href=\"https:\/\/stackify.com\/writing-better-sql-queries\/\">this one<\/a> for some of our recent SQL tips and tricks). Since SQL is pretty prominent in the development community,&nbsp;it&#8217;s crucial for developers to understand how CRUD operations work. So, this article is meant to bring you&nbsp;up to speed (if you&#8217;re not already) on CRUD operations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Definition of CRUD<\/h2>\n\n\n\n<p>Within computer programming, the acronym CRUD stands for create, read, update, and delete. These are the four basic functions of persistent storage. Also, each letter in the acronym can refer to all functions executed in relational database applications and mapped to a standard HTTP method, SQL statement, or DDS operation.<\/p>\n\n\n\n<p>It can <a href=\"https:\/\/softwareengineering.stackexchange.com\/questions\/120716\/difference-between-rest-and-crud\" target=\"_blank\" rel=\"noopener noreferrer\">also describe<\/a> user-interface conventions that allow viewing, searching, and modifying information through computer-based forms and reports. In essence, entities are read, created, updated, and deleted. Those same entities can be modified by taking the data from a service and changing the setting properties before sending the data back to the service for an update. Plus, CRUD is data-oriented and the standardized use of HTTP action verbs.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/stackify.com\/wp-content\/uploads\/2017\/05\/CRUD-Operations-Oracle.png\" alt=\"CRUD Operations\" class=\"wp-image-10936\"\/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\"><em>Screenshot Source: <a href=\"https:\/\/docs.oracle.com\/cloud\/latest\/globalcs_gs\/OESWH\/Standard_CRUD_Operations.htm\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle<\/a><\/em><\/p>\n\n\n\n<p>Most applications have some form of CRUD functionality. In fact, every programmer has had to deal with CRUD at some point. Not to mention, a CRUD application is one that utilizes forms to retrieve and return data from a database.<\/p>\n\n\n\n<p>The first reference to CRUD operations came from Haim Kilov in 1990 in an article titled, &#8220;From semantic to object-oriented data modeling.&#8221; However, the term was first made popular by James Martin&#8217;s 1983 book, <em>Managing the Data-base Environment<\/em>. Here\u2019s a breakdown:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>CREATE<\/strong> procedures: Performs the INSERT statement to create a new record in SQL databases.<\/li>\n\n\n\n<li><strong>READ<\/strong> procedures: Reads the table records based on the primary keynoted within the input parameter.<\/li>\n\n\n\n<li><strong>UPDATE<\/strong> procedures: Executes an UPDATE statement on the table based on the specified primary key for a record within the WHERE clause of the statement.<\/li>\n\n\n\n<li><strong>DELETE<\/strong> procedures: Deletes a specified row in the WHERE clause.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">How CRUD Works: Executing Operations and Examples<\/h2>\n\n\n\n<p>Based on the requirements of a system, varying user may have different <a href=\"http:\/\/searchdatamanagement.techtarget.com\/definition\/CRUD-cycle\" target=\"_blank\" rel=\"noopener noreferrer\">CRUD cycles<\/a>. A customer may use CRUD to create an account 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.<\/p>\n\n\n\n<p>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 &#8220;POST.&#8221; To update a record, you would use &#8220;PUT&#8221; or &#8220;PATCH.&#8221; If you wanted to delete a record, you would use &#8220;DELETE.&#8221; Through CRUD, users and administrators had the access rights to edit, delete, create or browse online records.<\/p>\n\n\n\n<p>An application designer has many options for executing CRUD operations. One of the most efficient of choices is to create a set of stored procedures in SQL to execute operations.<\/p>\n\n\n\n<p>Here\u2019s an example SQL procedure for CRUD operations on customer data.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">-- CREATE PROCEDURE\nCREATE PROCEDURE insert_customer (\n    IN first_name VARCHAR(50),\n    IN last_name VARCHAR(50),\n    IN email VARCHAR(100),\n    IN phone VARCHAR(20),\n    IN address VARCHAR(200)\n)\nBEGIN\n    INSERT INTO customers (first_name, last_name, email, phone, address)\n    VALUES (first_name, last_name, email, phone, address);\nEND;\n\n-- READ PROCEDURE\nCREATE PROCEDURE select_customer (\n    IN id INT\n)\nBEGIN\n    SELECT * FROM customers\n    WHERE customer_id = id;\nEND;\n\n-- UPDATE PROCEDURE\nCREATE PROCEDURE update_customer (\n    IN id INT,\n    IN first_name VARCHAR(50),\n    IN last_name VARCHAR(50),\n    IN email VARCHAR(100),\n    IN phone VARCHAR(20),\n    IN address VARCHAR(200)\n)\nBEGIN\n    UPDATE customers\n    SET first_name = first_name,\n        last_name = last_name,\n        email = email,\n        phone = phone,\n        address = address\n    WHERE customer_id = id;\nEND;\n\n-- DELETE PROCEDURE\nCREATE PROCEDURE delete_customer (\n    IN id INT\n)\nBEGIN\n    DELETE FROM customers\n    WHERE customer_id = id;\nEND;<\/pre>\n\n\n\n<p>You can check out a few more examples at the following resources:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"http:\/\/www.dineshonjava.com\/p\/crud-operations-using-hibernate-3.html\" target=\"_blank\" rel=\"noopener noreferrer\">CRUD Operations Using Hibernate (Annotation and Configuration)<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/www.gibraltarsoftware.com\/vistadb\/tutorials\/crud-examples\" target=\"_blank\" rel=\"noopener noreferrer\">Gibraltar &#8211; CRUD Examples<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/docs.aws.amazon.com\/amazondynamodb\/latest\/developerguide\/DynamoDBMapper.CRUDExample1.html\" target=\"_blank\" rel=\"noopener noreferrer\">Example: CRUD Operations &#8211; Amazon DynamoDB<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/avaldes.com\/mongodb-java-crud-operations-example-tutorial\/\" target=\"_blank\" rel=\"noopener noreferrer\">MongoDB Java CRUD Operations Example Tutorial<\/a><\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Benefits of CRUD<\/h2>\n\n\n\n<p>Instead of using ad-hoc SQL statements, many programmers prefer to use CRUD because of its performance. When a stored procedure is first executed, the execution plan is stored in SQL Server&#8217;s procedure cache and reused for all applications of the stored procedure.<\/p>\n\n\n\n<p>When a SQL statement is executed in SQL Server, the relational engine searches the procedure cache to ensure an existing execution plan for that particular SQL statement is available and uses the current plan to decrease the need for optimization, parsing, and recompiling steps for the SQL statement.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" src=\"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/preferCRUD.png\" alt=\"Many programmers prefer to use CRUD because of its performance. \" class=\"wp-image-36274\"\/><\/figure><\/div>\n\n\n<p>If an execution plan is not available, then the SQL Server will create a new execution plan for the query. Moreover, when you remove SQL statements from the application code, all the SQL can be kept in the database while only stored procedure invocations are in the client application. When you use stored procedures, it helps to decrease database coupling.<\/p>\n\n\n\n<p>Furthermore, using CRUD operations helps to prevent SQL injection attacks. By utilizing stored procedures instead of string concatenation to build dynamic queries from user input data for all SQL Statements means that everything placed into a parameter gets quoted.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">CRUD Prevents Casual Browsing and Changes<\/h2>\n\n\n\n<p>Application roles are a SQL Server technique that lets code switch identities without informing the user. To work with ad hoc SQL statements, users must have the required permissions on the database tables. Once permission is granted, users can read and manipulate data in applications such as Excel, Word, and others. Users can even bypass the application&#8217;s business rules.<\/p>\n\n\n\n<p>Yet, this is an unwanted situation that can be prevented through the Application Role. Through integrated security for database access and an Application Role, these types of loopholes can be closed. CRUD comes in since Application roles are added to the database using a stored procedure. It is also implemented by granting permission to execute the CRUD stored procedures and revoking direct access to the tables.<\/p>\n\n\n\n<p>Once an Application Role is added, permissions are assigned, and a password is given. The password is also coded into the application, making it difficult to change. For manipulating data, CRUD is the method to use.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">CRUD Operations using NodeJS<\/h2>\n\n\n\n<p>Many programmers instead use backend APIs to perform CRUD operations. APIs are flexible, enable API testing, and are much easier to maintain. Let&#8217;s build a sample NodeJS application to perform CRUD operations using MySQL DB.<\/p>\n\n\n\n<p>1. Create a DB connection by installing mysql&nbsp; NPM module.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">const mysql = require('mysql');\n\nconst connection = mysql.createConnection({\n  host: 'localhost',\n  user: 'yourusername',\n  password: 'yourpassword',\n  database: 'yourdatabase'\n});\n\nconnection.connect((err) =&gt; {\n  if (err) throw err;\n  console.log('Connected to MySQL server!');\n});<\/pre>\n\n\n\n<p>2. Create a function to add (CREATE), read (READ), update(UPDATE), and delete data (DELETE operation).<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">function createData(data) {\n  connection.query('INSERT INTO your_table SET ?', data, (err, res) =&gt; {\n    if (err) throw err;\n    console.log('New data added:', res.insertId);\n  });\n}\nfunction retrieveData(id) {\n  connection.query('SELECT * FROM your_table WHERE id = ?', [id], (err, res) =&gt; {\n    if (err) throw err;\n    console.log(res[0]);\n  });\n}\nfunction updateData(id, data) {\n  connection.query('UPDATE your_table SET ? WHERE id = ?', [data, id], (err, res) =&gt; {\n    if (err) throw err;\n    console.log('Data updated:', res.affectedRows);\n  });\n}\nfunction deleteData(id) {\n  connection.query('DELETE FROM your_table WHERE id = ?', [id], (err, res) =&gt; {\n    if (err) throw err;\n    console.log('Data deleted:', res.affectedRows);\n  });\n}<\/pre>\n\n\n\n<p>3. Use the functions we just built to perform CRUD operations<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">const data = { name: 'John Doe', age: 30, email: 'johndoe@example.com' };\n\n\/\/ create new data\ncreateData(data);\n\n\/\/ retrieve data\nretrieveData(1);\n\n\/\/ update data\nupdateData(1, { name: 'John Doe' });\n\n\/\/ delete data\ndeleteData(1);<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Using SQL Procedures with NodeJS<\/h2>\n\n\n\n<p>Developers can also use the SQL procedures directly with NodeJS. Let&#8217;s write a function to perform CREATE operation using the SQL procedure we just wrote.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">function insertCustomer(first_name, last_name, email, phone, address) {\n  return new Promise((resolve, reject) =&gt; {\n    connection.query(\n      'CALL insert_customer(?, ?, ?, ?, ?)',\n      [first_name, last_name, email, phone, address],\n      (error, results, fields) =&gt; {\n        if (error) {\n          return reject(error);\n        }\n        return resolve(results[0]);\n      }\n    );\n  });\n}<\/pre>\n\n\n\n<p>You can call this function (which uses SQL stored procedure) based on your use case.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">insertCustomer('John', 'Doe', 'johndoe@example.com', '555-1234', '123 Main St.')\n  .then(result =&gt; {\n    console.log(result);\n  })\n  .catch(error =&gt; {\n    console.error(error);\n  });<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Resources and Tutorials on CRUD Operations<\/h2>\n\n\n\n<p>For more information on CRUD operations, including tutorials on using and executing CRUD operations effectively with different languages, visit the following links:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"http:\/\/mongodb.github.io\/node-mongodb-native\/2.2\/tutorials\/crud\/\" target=\"_blank\" rel=\"noopener noreferrer\">MongoDB &#8211; CRUD Operations<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/propelorm.org\/documentation\/03-basic-crud.html\" target=\"_blank\" rel=\"noopener noreferrer\">Propel &#8211;&nbsp;Basic C.R.U.D. Operations<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/couchbase-live-new-york-couchbase-101-how-to-build-your-first-couchbase-mobile-app\/\" target=\"_blank\" rel=\"noopener noreferrer\">Performing CRUD operations<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blog.theinfosecguy.xyz\/building-a-crud-api-with-fastapi-and-supabase-a-step-by-step-guide\">Building a CRUD API with FastAPI and Supabase<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/aspnet\/mvc\/overview\/getting-started\/getting-started-with-ef-using-mvc\/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-application\" target=\"_blank\" rel=\"noopener noreferrer\">Implementing Basic CRUD Functionality with the Entity Framework in ASP.NET MVC Application<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/zellwk.com\/blog\/crud-express-mongodb\/\" target=\"_blank\" rel=\"noopener noreferrer\">Building a Simple CRUD Application with Express and MongoDB<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/www.objectdb.com\/java\/jpa\/persistence\/crud\" target=\"_blank\" rel=\"noopener noreferrer\">CRUD Operations with JPA<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/www.appcelerator.com\/blog\/2010\/07\/how-to-perform-crud-operations-on-a-local-database\/\" target=\"_blank\" rel=\"noopener noreferrer\">How-To: Perform CRUD operations on a local database<\/a><\/li>\n\n\n\n<li><a href=\"http:\/\/docs.basho.com\/riak\/kv\/2.2.3\/developing\/getting-started\/java\/crud-operations\/\" target=\"_blank\" rel=\"noopener noreferrer\">Getting Started: CRUD Operations with Java<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/teamtreehouse.com\/library\/what-is-crud\" target=\"_blank\" rel=\"noopener noreferrer\">CRUD Operations with PHP<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/blogs.sap.com\/2015\/12\/28\/crud-operations-with-xsjs-as-services\/\" target=\"_blank\" rel=\"noopener noreferrer\">CRUD Operations with XSJS \u2013 SAP HANA Native Application<\/a><\/li>\n<\/ul>\n\n\n\n<p>Try Stackify&#8217;s free code profiler,<a href=\"https:\/\/stackify.com\/prefix\"> Prefix<\/a>, to write better code on your workstation. Prefix works with .NET, Java, PHP, Node.js, Ruby, and Python.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since SQL is pretty prominent in the dev community, it&#8217;s crucial for developers to understand how CRUD operations work. Get up to speed on CRUD operations.<\/p>\n","protected":false},"author":3,"featured_media":36998,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[7],"tags":[68],"class_list":["post-10935","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developers","tag-sql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.6 (Yoast SEO v25.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What are CRUD Operations? Examples, Tutorials &amp; More<\/title>\n<meta name=\"description\" content=\"Since SQL is pretty prominent in the dev community, it&#039;s crucial for developers to understand how CRUD operations work. Get up to speed on CRUD operations.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stackify.com\/what-are-crud-operations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What are CRUD Operations? Examples, Tutorials &amp; More\" \/>\n<meta property=\"og:description\" content=\"Since SQL is pretty prominent in the dev community, it&#039;s crucial for developers to understand how CRUD operations work. Get up to speed on CRUD operations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stackify.com\/what-are-crud-operations\/\" \/>\n<meta property=\"og:site_name\" content=\"Stackify\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Stackify\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-16T15:07:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-18T04:34:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1100\" \/>\n\t<meta property=\"og:image:height\" content=\"650\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alexandra Altvater\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@stackify\" \/>\n<meta name=\"twitter:site\" content=\"@stackify\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alexandra Altvater\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/stackify.com\/what-are-crud-operations\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/stackify.com\/what-are-crud-operations\/\"},\"author\":{\"name\":\"Alexandra Altvater\",\"@id\":\"https:\/\/stackify.com\/#\/schema\/person\/3087594560b933be18c662a37d09b51a\"},\"headline\":\"What are CRUD Operations: How CRUD Operations Work, Examples, Tutorials &#038; More\",\"datePublished\":\"2023-03-16T15:07:00+00:00\",\"dateModified\":\"2024-04-18T04:34:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/stackify.com\/what-are-crud-operations\/\"},\"wordCount\":1193,\"publisher\":{\"@id\":\"https:\/\/stackify.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/stackify.com\/what-are-crud-operations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png\",\"keywords\":[\"SQL\"],\"articleSection\":[\"Developer Tips, Tricks &amp; Resources\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stackify.com\/what-are-crud-operations\/\",\"url\":\"https:\/\/stackify.com\/what-are-crud-operations\/\",\"name\":\"What are CRUD Operations? Examples, Tutorials & More\",\"isPartOf\":{\"@id\":\"https:\/\/stackify.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/stackify.com\/what-are-crud-operations\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/stackify.com\/what-are-crud-operations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png\",\"datePublished\":\"2023-03-16T15:07:00+00:00\",\"dateModified\":\"2024-04-18T04:34:41+00:00\",\"description\":\"Since SQL is pretty prominent in the dev community, it's crucial for developers to understand how CRUD operations work. Get up to speed on CRUD operations.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stackify.com\/what-are-crud-operations\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/stackify.com\/what-are-crud-operations\/#primaryimage\",\"url\":\"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png\",\"contentUrl\":\"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png\",\"width\":1100,\"height\":650},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stackify.com\/#website\",\"url\":\"https:\/\/stackify.com\/\",\"name\":\"Stackify\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/stackify.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stackify.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/stackify.com\/#organization\",\"name\":\"Stackify\",\"url\":\"https:\/\/stackify.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/stackify.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/stackify.com\/wp-content\/uploads\/2024\/05\/logo-1.png\",\"contentUrl\":\"https:\/\/stackify.com\/wp-content\/uploads\/2024\/05\/logo-1.png\",\"width\":1377,\"height\":430,\"caption\":\"Stackify\"},\"image\":{\"@id\":\"https:\/\/stackify.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/Stackify\/\",\"https:\/\/x.com\/stackify\",\"https:\/\/www.instagram.com\/stackify\/\",\"https:\/\/www.linkedin.com\/company\/2596184\",\"https:\/\/www.youtube.com\/stackify\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/stackify.com\/#\/schema\/person\/3087594560b933be18c662a37d09b51a\",\"name\":\"Alexandra Altvater\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/stackify.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e0459a6d11f4f510127934dfd98b94?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e0459a6d11f4f510127934dfd98b94?s=96&d=mm&r=g\",\"caption\":\"Alexandra Altvater\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"What are CRUD Operations? Examples, Tutorials & More","description":"Since SQL is pretty prominent in the dev community, it's crucial for developers to understand how CRUD operations work. Get up to speed on CRUD operations.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/stackify.com\/what-are-crud-operations\/","og_locale":"en_US","og_type":"article","og_title":"What are CRUD Operations? Examples, Tutorials & More","og_description":"Since SQL is pretty prominent in the dev community, it's crucial for developers to understand how CRUD operations work. Get up to speed on CRUD operations.","og_url":"https:\/\/stackify.com\/what-are-crud-operations\/","og_site_name":"Stackify","article_publisher":"https:\/\/www.facebook.com\/Stackify\/","article_published_time":"2023-03-16T15:07:00+00:00","article_modified_time":"2024-04-18T04:34:41+00:00","og_image":[{"width":1100,"height":650,"url":"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png","type":"image\/png"}],"author":"Alexandra Altvater","twitter_card":"summary_large_image","twitter_creator":"@stackify","twitter_site":"@stackify","twitter_misc":{"Written by":"Alexandra Altvater","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/stackify.com\/what-are-crud-operations\/#article","isPartOf":{"@id":"https:\/\/stackify.com\/what-are-crud-operations\/"},"author":{"name":"Alexandra Altvater","@id":"https:\/\/stackify.com\/#\/schema\/person\/3087594560b933be18c662a37d09b51a"},"headline":"What are CRUD Operations: How CRUD Operations Work, Examples, Tutorials &#038; More","datePublished":"2023-03-16T15:07:00+00:00","dateModified":"2024-04-18T04:34:41+00:00","mainEntityOfPage":{"@id":"https:\/\/stackify.com\/what-are-crud-operations\/"},"wordCount":1193,"publisher":{"@id":"https:\/\/stackify.com\/#organization"},"image":{"@id":"https:\/\/stackify.com\/what-are-crud-operations\/#primaryimage"},"thumbnailUrl":"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png","keywords":["SQL"],"articleSection":["Developer Tips, Tricks &amp; Resources"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/stackify.com\/what-are-crud-operations\/","url":"https:\/\/stackify.com\/what-are-crud-operations\/","name":"What are CRUD Operations? Examples, Tutorials & More","isPartOf":{"@id":"https:\/\/stackify.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/stackify.com\/what-are-crud-operations\/#primaryimage"},"image":{"@id":"https:\/\/stackify.com\/what-are-crud-operations\/#primaryimage"},"thumbnailUrl":"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png","datePublished":"2023-03-16T15:07:00+00:00","dateModified":"2024-04-18T04:34:41+00:00","description":"Since SQL is pretty prominent in the dev community, it's crucial for developers to understand how CRUD operations work. Get up to speed on CRUD operations.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stackify.com\/what-are-crud-operations\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/stackify.com\/what-are-crud-operations\/#primaryimage","url":"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png","contentUrl":"https:\/\/stackify.com\/wp-content\/uploads\/2023\/02\/What-are-CRUD-Operations-How-CRUD-Operations-Work-Examples-Tutorials-More.png","width":1100,"height":650},{"@type":"WebSite","@id":"https:\/\/stackify.com\/#website","url":"https:\/\/stackify.com\/","name":"Stackify","description":"","publisher":{"@id":"https:\/\/stackify.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stackify.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/stackify.com\/#organization","name":"Stackify","url":"https:\/\/stackify.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/stackify.com\/#\/schema\/logo\/image\/","url":"https:\/\/stackify.com\/wp-content\/uploads\/2024\/05\/logo-1.png","contentUrl":"https:\/\/stackify.com\/wp-content\/uploads\/2024\/05\/logo-1.png","width":1377,"height":430,"caption":"Stackify"},"image":{"@id":"https:\/\/stackify.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Stackify\/","https:\/\/x.com\/stackify","https:\/\/www.instagram.com\/stackify\/","https:\/\/www.linkedin.com\/company\/2596184","https:\/\/www.youtube.com\/stackify"]},{"@type":"Person","@id":"https:\/\/stackify.com\/#\/schema\/person\/3087594560b933be18c662a37d09b51a","name":"Alexandra Altvater","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/stackify.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/99e0459a6d11f4f510127934dfd98b94?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e0459a6d11f4f510127934dfd98b94?s=96&d=mm&r=g","caption":"Alexandra Altvater"}}]}},"_links":{"self":[{"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/posts\/10935"}],"collection":[{"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/comments?post=10935"}],"version-history":[{"count":0,"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/posts\/10935\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/media\/36998"}],"wp:attachment":[{"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/media?parent=10935"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/categories?post=10935"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stackify.com\/wp-json\/wp\/v2\/tags?post=10935"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}