{"id":193878,"date":"2025-03-03T06:30:00","date_gmt":"2025-03-03T05:30:00","guid":{"rendered":"https:\/\/liora.io\/en\/?p=193878"},"modified":"2026-08-07T10:24:28","modified_gmt":"2026-08-07T09:24:28","slug":"managing-table-data-in-sql","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/managing-table-data-in-sql","title":{"rendered":"Managing Table Data: INSERT, UPDATE, DELETE with SQL"},"content":{"rendered":"\n

Tables store data that can be used or referenced in the future. Over time, it is common to modify this data to ensure it remains relevant and up-to-date. In this article, you will learn three essential SQL commands to modify data: UPDATE, INSERT, and DELETE.<\/strong><\/p>\n\n\n

UPDATE: Changing Existing Data<\/strong><\/h2>\n\n\n

The UPDATE statement allows you to modify existing records in a table.<\/p>\n\n\n

Example:<\/strong><\/p>\n\n\n

Imagine you have a Product Information Table (<\/strong>product_info<\/strong>)<\/strong> for your kitchenware business. This table contains details about all products, including attributes such as product_id, product_name, weight, material, fabrication_country, cost, and price.<\/p>\n\n\n

Before Update:<\/strong><\/p>\n\n\n

\"Illustration<\/figure>\n\n\n

If the cost of borosilicate glass, used in your glass baking pan, increases, you need to update the cost data for this specific product.<\/p>\n\n\n

SQL Script:<\/strong><\/p>\n\n\n

UPDATE product_info<\/p>\n\n\n

SET cost = cost * 1.25<\/p>\n\n\n

WHERE product_name = ‘baking pan’ AND material = ‘glass’;<\/p>\n\n\n

After Update:<\/strong><\/p>\n\n\n

\"Illustration<\/figure>\n\n\n
Master SQL for data science<\/a><\/div><\/div>\n\n\n

INSERT: Adding New Data<\/strong><\/h2>\n\n\n

The INSERT statement allows you to add new records to a table.<\/p>\n\n\n

Example:<\/strong><\/p>\n\n\n

As environmental concerns grow, sustainable materials are becoming popular. You decide to introduce a new baking pan made of carbon steel<\/strong>, which is durable, versatile, and heat-tolerant. You can use INSERT to add this new product to your table.<\/p>\n\n\n

Before Insert:<\/strong><\/p>\n\n\n

SQL Script:<\/strong><\/p>\n\n\n

INSERT INTO product_info (product_id, product_name, weight, material, fabrication_country, cost, price)<\/p>\n\n\n

VALUES (235, ‘baking pan’, 0.25, ‘carbon steel’, ‘France’, 9, 16);<\/p>\n\n\n

After Insert:<\/strong><\/p>\n\n\n

\"Illustration<\/figure>\n\n\n\n

DELETE: Removing Data<\/strong><\/h2>\n\n\n

The DELETE statement allows you to remove records from a table.<\/p>\n\n\n

Example:<\/strong><\/p>\n\n\n

Due to global supply chain disruptions, you decide to discontinue a stoneware baking pan<\/strong>. To remove it from your product catalog, use the DELETE statement.<\/p>\n\n\n

Before Delete:<\/strong><\/p>\n\n\n

\"Illustration<\/figure>\n\n\n

SQL Script:<\/strong><\/p>\n\n\n

DELETE FROM product_info<\/p>\n\n\n

WHERE product_name = ‘baking pan’ AND material = ‘stoneware’;<\/p>\n\n\n

After Delete:<\/strong><\/p>\n\n\n

\"Illustration<\/figure>\n\n\n
Learn more about SQL<\/a><\/div><\/div>\n\n\n

Conclusion<\/strong><\/h2>\n\n\n

Understanding how to modify data in SQL is crucial for maintaining accurate and up-to-date databases. Here\u2019s a quick recap:<\/p>\n\n\n

    \n
  • UPDATE<\/strong> modifies existing records.<\/li>\n
  • INSERT<\/strong> adds new records.<\/li>\n
  • DELETE<\/strong> removes records from a table.<\/li>\n<\/ul>\n\n\n

    Mastering these commands will help you manage databases efficiently and keep your data relevant!<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"

    Tables store data that can be used or referenced in the future. Over time, it is common to modify this data to ensure it remains relevant and up-to-date. In this article, you will learn three essential SQL commands to modify data: UPDATE, INSERT, and DELETE. UPDATE: Changing Existing Data The UPDATE statement allows you to […]<\/p>\n","protected":false},"author":99,"featured_media":193880,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-193878","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/193878","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/99"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=193878"}],"version-history":[{"count":5,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/193878\/revisions"}],"predecessor-version":[{"id":209739,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/193878\/revisions\/209739"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/193880"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=193878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=193878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}