{"id":11624,"date":"2025-12-03T17:16:02","date_gmt":"2025-12-03T17:16:02","guid":{"rendered":"https:\/\/savethevideo.net\/blog\/?p=11624"},"modified":"2025-12-03T17:18:32","modified_gmt":"2025-12-03T17:18:32","slug":"update-command-in-sql-modifying-existing-records","status":"publish","type":"post","link":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/","title":{"rendered":"Update command in SQL: Modifying Existing Records"},"content":{"rendered":"<p>Whether you\u2019re building an app, managing a website, or playing around with databases, you\u2019ll come across situations where you need to change some data. That\u2019s where SQL\u2019s <em>UPDATE<\/em> command steps in. It lets you modify and correct data in your tables, keeping everything nice and tidy.<\/p>\n<p><strong>TL;DR:<\/strong> The <em>UPDATE<\/em> command in SQL is used to change existing records in a database. You use it along with the <em>SET<\/em> and <em>WHERE<\/em> clauses to pick what data to change and how to change it. It\u2019s powerful, but you need to be careful\u2014especially when using it without a <em>WHERE<\/em> clause! Let us guide you through the basics with a fun and simple approach.<\/p>\n<h2>Why Should You Care About UPDATE?<\/h2>\n<p>Updating data helps keep your information current. Imagine you&#8217;re managing a user list. Someone changes their email or name\u2014do you delete and re-add them? Nope! You just <em>update<\/em> their info.<\/p>\n<p>Here\u2019s another example. A product\u2019s price changes? No problem. Just update that one field instead of recreating the entire record.<\/p>\n<h3>When to Use UPDATE<\/h3>\n<ul>\n<li>Correcting a mistake (Oops, wrong phone number!)<\/li>\n<li>Changing values (New email, new zip code\u2026)<\/li>\n<li>Bulk changes (Everyone gets a 10% discount!)<\/li>\n<\/ul>\n<h2>The Basic Structure of UPDATE<\/h2>\n<p>Let\u2019s break it down. The SQL <strong>UPDATE<\/strong> command follows this simple structure:<\/p>\n<pre>\nUPDATE table_name\nSET column1 = value1, column2 = value2, ...\nWHERE condition;\n<\/pre>\n<p>Sounds easy, right? Let\u2019s see it in action.<\/p>\n<h3>Example: Changing a User\u2019s Email<\/h3>\n<p>Let\u2019s say we have a table called <strong>users<\/strong>:<\/p>\n<pre>\n+----+---------+--------------------+\n| id | name    | email              |\n+----+---------+--------------------+\n| 1  | Alice   | alice@example.com  |\n| 2  | Bob     | bob@example.com    |\n+----+---------+--------------------+\n<\/pre>\n<p>Now Bob gets a new email. Here\u2019s what you do:<\/p>\n<pre>\nUPDATE users\nSET email = 'newbob@example.com'\nWHERE id = 2;\n<\/pre>\n<p>Boom! Bob\u2019s email is now up to date.<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"1080\" src=\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-stack-of-stacked-blue-and-white-plates-update-command-sql-query-database-table.jpg\" class=\"attachment-full size-full\" alt=\"\" srcset=\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-stack-of-stacked-blue-and-white-plates-update-command-sql-query-database-table.jpg 1080w, https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-stack-of-stacked-blue-and-white-plates-update-command-sql-query-database-table-300x300.jpg 300w, https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-stack-of-stacked-blue-and-white-plates-update-command-sql-query-database-table-1024x1024.jpg 1024w, https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-stack-of-stacked-blue-and-white-plates-update-command-sql-query-database-table-150x150.jpg 150w, https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-stack-of-stacked-blue-and-white-plates-update-command-sql-query-database-table-768x768.jpg 768w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/>\n<h2>Watch Out for This Trap!<\/h2>\n<p>Warning! If you forget the <strong>WHERE<\/strong> clause, it will update <em>every row<\/em> in the table. Yes, every single one.<\/p>\n<p>Example:<\/p>\n<pre>\nUPDATE users\nSET email = 'new@example.com';\n<\/pre>\n<p>This command changes <strong>everyone\u2019s<\/strong> email to &#8216;new@example.com&#8217;&#8230; Yikes!<\/p>\n<h3>Tips to Stay Safe<\/h3>\n<ul>\n<li><strong>Always double-check<\/strong> your WHERE clause.<\/li>\n<li>Use a <em>SELECT<\/em> query first to test which rows will update.<\/li>\n<li>Take database backups when working with important data.<\/li>\n<\/ul>\n<h2>Updating Multiple Rows<\/h2>\n<p>Let\u2019s say we want to give a 10% discount to all premium users in a <strong>subscriptions<\/strong> table:<\/p>\n<pre>\nUPDATE subscriptions\nSET price = price * 0.9\nWHERE plan = 'premium';\n<\/pre>\n<p>Now all premium users get a discount. Easy, right?<\/p>\n<h2>Updating Multiple Columns<\/h2>\n<p>You\u2019re not stuck with just one column at a time. You can update several fields at once:<\/p>\n<pre>\nUPDATE users\nSET name = 'Robert', email = 'robert@example.com'\nWHERE id = 2;\n<\/pre>\n<p>This updates both the name and the email of the user with id 2.<\/p>\n<h2>UPDATE with Other SQL Magic<\/h2>\n<p>Yes, you can combine UPDATE with joins, subqueries, and even more powerful logic! But we\u2019ll keep things simple for now. Here&#8217;s a sneak peek:<\/p>\n<pre>\nUPDATE orders\nSET status = 'shipped'\nWHERE order_date &lt; '2024-05-01';\n<\/pre>\n<p>This could update older orders so their status becomes &#8216;shipped&#8217;.<\/p>\n<img loading=\"lazy\" decoding=\"async\" width=\"1080\" height=\"570\" src=\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-blue-and-orange-dollar-sign-sitting-on-top-of-each-other-sql-join-vs-subquery-database-performance-data-relationships.jpg\" class=\"attachment-full size-full\" alt=\"\" srcset=\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-blue-and-orange-dollar-sign-sitting-on-top-of-each-other-sql-join-vs-subquery-database-performance-data-relationships.jpg 1080w, https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-blue-and-orange-dollar-sign-sitting-on-top-of-each-other-sql-join-vs-subquery-database-performance-data-relationships-300x158.jpg 300w, https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-blue-and-orange-dollar-sign-sitting-on-top-of-each-other-sql-join-vs-subquery-database-performance-data-relationships-1024x540.jpg 1024w, https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/a-blue-and-orange-dollar-sign-sitting-on-top-of-each-other-sql-join-vs-subquery-database-performance-data-relationships-768x405.jpg 768w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/>\n<h2>Fun Fact: UPDATE Returns a Count!<\/h2>\n<p>Did you know that most SQL systems will tell you how many rows were affected by an <em>UPDATE<\/em>? Very useful to confirm your action worked.<\/p>\n<p>So when you run:<\/p>\n<pre>\nUPDATE users\nSET name = 'Charlie'\nWHERE id = 42;\n<\/pre>\n<p>You might get a message saying: <em>1 row affected<\/em>.<\/p>\n<p>If you see: <em>0 rows affected<\/em>, that means the <strong>condition<\/strong> didn&#8217;t match any rows. Double-check that WHERE clause again!<\/p>\n<h2>Using UPDATE in Real Life<\/h2>\n<p>Let\u2019s say you&#8217;re running an online bookstore. Books go on sale, customers update their addresses, inventory levels change\u2026 You\u2019ll be using UPDATE a lot.<\/p>\n<p>Here are a few real-world examples:<\/p>\n<ul>\n<li><strong>Inventory:<\/strong><br \/>\n    <\/p>\n<pre>UPDATE books SET stock = stock - 1 WHERE id = 101;<\/pre>\n<\/li>\n<li><strong>Address change:<\/strong><br \/>\n    <\/p>\n<pre>UPDATE customers SET city = 'Toronto' WHERE postal_code = '90001';<\/pre>\n<\/li>\n<li><strong>Mark as Active:<\/strong><br \/>\n    <\/p>\n<pre>UPDATE users SET active = TRUE WHERE last_login &gt;= '2024-06-01';<\/pre>\n<\/li>\n<\/ul>\n<h2>Bonus: UPDATE + Returning Data<\/h2>\n<p>Some systems like PostgreSQL let you return data right after an update:<\/p>\n<pre>\nUPDATE users\nSET name = 'Alex'\nWHERE id = 5\nRETURNING *;\n<\/pre>\n<p>This gives you the updated row back immediately. Super handy!<\/p>\n<h2>Things to Remember<\/h2>\n<ul>\n<li><strong>UPDATE<\/strong> changes data, not structure.<\/li>\n<li>Use <em>SET<\/em> to decide what to change.<\/li>\n<li>Always use <strong>WHERE<\/strong> unless you want to change <em>every<\/em> row.<\/li>\n<li>Test with SELECT first if you\u2019re unsure.<\/li>\n<\/ul>\n<h2>Final Thoughts<\/h2>\n<p>The <strong>UPDATE<\/strong> command is one of SQL\u2019s greatest tools. It lets you fix typos, change prices, handle customer updates, and more. If your data is alive and changing, <em>UPDATE<\/em> is your best friend.<\/p>\n<p>Just treat it with care. Think before you run it. And always, always keep that WHERE clause in check.<\/p>\n<p>Happy updating!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Whether you\u2019re building an app, managing a website, or playing around with databases, you\u2019ll come across situations where you need to change some data. That\u2019s where SQL\u2019s UPDATE command steps &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Update command in SQL: Modifying Existing Records\" class=\"read-more button\" href=\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#more-11624\" aria-label=\"Read more about Update command in SQL: Modifying Existing Records\">Read more<\/a><\/p>\n","protected":false},"author":88,"featured_media":11625,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[495],"tags":[],"class_list":["post-11624","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Update command in SQL: Modifying Existing Records - Save the Video Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Update command in SQL: Modifying Existing Records - Save the Video Blog\" \/>\n<meta property=\"og:description\" content=\"Whether you\u2019re building an app, managing a website, or playing around with databases, you\u2019ll come across situations where you need to change some data. That\u2019s where SQL\u2019s UPDATE command steps ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/\" \/>\n<meta property=\"og:site_name\" content=\"Save the Video Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-12-03T17:16:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-03T17:18:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jonathan Dough\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan Dough\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/\"},\"author\":{\"name\":\"Jonathan Dough\",\"@id\":\"https:\/\/savethevideo.net\/blog\/#\/schema\/person\/2fd5bb6675327a328b726eb409570700\"},\"headline\":\"Update command in SQL: Modifying Existing Records\",\"datePublished\":\"2025-12-03T17:16:02+00:00\",\"dateModified\":\"2025-12-03T17:18:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/\"},\"wordCount\":672,\"publisher\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/\",\"url\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/\",\"name\":\"Update command in SQL: Modifying Existing Records - Save the Video Blog\",\"isPartOf\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg\",\"datePublished\":\"2025-12-03T17:16:02+00:00\",\"dateModified\":\"2025-12-03T17:18:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#primaryimage\",\"url\":\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg\",\"contentUrl\":\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg\",\"width\":1080,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/savethevideo.net\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Update command in SQL: Modifying Existing Records\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/savethevideo.net\/blog\/#website\",\"url\":\"https:\/\/savethevideo.net\/blog\/\",\"name\":\"Save the Video Blog\",\"description\":\"Everything you need to know about videos\",\"publisher\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/savethevideo.net\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/savethevideo.net\/blog\/#organization\",\"name\":\"Save the Video Blog\",\"url\":\"https:\/\/savethevideo.net\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/savethevideo.net\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2021\/02\/cropped-stv-logo.png\",\"contentUrl\":\"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2021\/02\/cropped-stv-logo.png\",\"width\":500,\"height\":119,\"caption\":\"Save the Video Blog\"},\"image\":{\"@id\":\"https:\/\/savethevideo.net\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/savethevideo.net\/blog\/#\/schema\/person\/2fd5bb6675327a328b726eb409570700\",\"name\":\"Jonathan Dough\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/savethevideo.net\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9afc32c64534e0fac8123f418680cd8c214b1c82b9a0e765b34eddf7636ede6d?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9afc32c64534e0fac8123f418680cd8c214b1c82b9a0e765b34eddf7636ede6d?s=96&d=monsterid&r=g\",\"caption\":\"Jonathan Dough\"},\"url\":\"https:\/\/savethevideo.net\/blog\/author\/jonathand\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Update command in SQL: Modifying Existing Records - Save the Video Blog","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:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/","og_locale":"en_US","og_type":"article","og_title":"Update command in SQL: Modifying Existing Records - Save the Video Blog","og_description":"Whether you\u2019re building an app, managing a website, or playing around with databases, you\u2019ll come across situations where you need to change some data. That\u2019s where SQL\u2019s UPDATE command steps ... Read more","og_url":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/","og_site_name":"Save the Video Blog","article_published_time":"2025-12-03T17:16:02+00:00","article_modified_time":"2025-12-03T17:18:32+00:00","og_image":[{"width":1080,"height":720,"url":"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg","type":"image\/jpeg"}],"author":"Jonathan Dough","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathan Dough","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#article","isPartOf":{"@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/"},"author":{"name":"Jonathan Dough","@id":"https:\/\/savethevideo.net\/blog\/#\/schema\/person\/2fd5bb6675327a328b726eb409570700"},"headline":"Update command in SQL: Modifying Existing Records","datePublished":"2025-12-03T17:16:02+00:00","dateModified":"2025-12-03T17:18:32+00:00","mainEntityOfPage":{"@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/"},"wordCount":672,"publisher":{"@id":"https:\/\/savethevideo.net\/blog\/#organization"},"image":{"@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#primaryimage"},"thumbnailUrl":"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg","articleSection":["Blog"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/","url":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/","name":"Update command in SQL: Modifying Existing Records - Save the Video Blog","isPartOf":{"@id":"https:\/\/savethevideo.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#primaryimage"},"image":{"@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#primaryimage"},"thumbnailUrl":"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg","datePublished":"2025-12-03T17:16:02+00:00","dateModified":"2025-12-03T17:18:32+00:00","breadcrumb":{"@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#primaryimage","url":"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg","contentUrl":"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2025\/12\/computer-screen-showing-lines-of-code-update-command-sql-query-database-table.jpg","width":1080,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/savethevideo.net\/blog\/update-command-in-sql-modifying-existing-records\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/savethevideo.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Update command in SQL: Modifying Existing Records"}]},{"@type":"WebSite","@id":"https:\/\/savethevideo.net\/blog\/#website","url":"https:\/\/savethevideo.net\/blog\/","name":"Save the Video Blog","description":"Everything you need to know about videos","publisher":{"@id":"https:\/\/savethevideo.net\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/savethevideo.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/savethevideo.net\/blog\/#organization","name":"Save the Video Blog","url":"https:\/\/savethevideo.net\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/savethevideo.net\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2021\/02\/cropped-stv-logo.png","contentUrl":"https:\/\/savethevideo.net\/blog\/wp-content\/uploads\/2021\/02\/cropped-stv-logo.png","width":500,"height":119,"caption":"Save the Video Blog"},"image":{"@id":"https:\/\/savethevideo.net\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/savethevideo.net\/blog\/#\/schema\/person\/2fd5bb6675327a328b726eb409570700","name":"Jonathan Dough","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/savethevideo.net\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9afc32c64534e0fac8123f418680cd8c214b1c82b9a0e765b34eddf7636ede6d?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9afc32c64534e0fac8123f418680cd8c214b1c82b9a0e765b34eddf7636ede6d?s=96&d=monsterid&r=g","caption":"Jonathan Dough"},"url":"https:\/\/savethevideo.net\/blog\/author\/jonathand\/"}]}},"_links":{"self":[{"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/posts\/11624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/users\/88"}],"replies":[{"embeddable":true,"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/comments?post=11624"}],"version-history":[{"count":1,"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/posts\/11624\/revisions"}],"predecessor-version":[{"id":11631,"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/posts\/11624\/revisions\/11631"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/media\/11625"}],"wp:attachment":[{"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/media?parent=11624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/categories?post=11624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savethevideo.net\/blog\/wp-json\/wp\/v2\/tags?post=11624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}