{"id":175680,"date":"2024-01-04T18:07:54","date_gmt":"2024-01-04T17:07:54","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=175680"},"modified":"2024-01-04T18:14:32","modified_gmt":"2024-01-04T17:14:32","slug":"sql-update-update-data-with-this-command","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command","title":{"rendered":"SQL UPDATE: Update data with this command"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"175680\" class=\"elementor elementor-175680\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-13c83c4 e-flex e-con-boxed e-con\" data-id=\"13c83c4\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0da5dc9 elementor-widget elementor-widget-heading\" data-id=\"0da5dc9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Because databases are constantly evolving, it's essential to be familiar with the UPDATE SQL query. This allows you to modify one or more rows in your table. So how do you use it? We explain it all in this article.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ec5e158 e-flex e-con-boxed e-con\" data-id=\"ec5e158\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8623016 elementor-widget elementor-widget-heading\" data-id=\"8623016\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is SQL UPDATE?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aff864b elementor-widget elementor-widget-text-editor\" data-id=\"aff864b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>The <strong>SQL UPDATE<\/strong> command is used to update data within a table. It&#8217;s essential if you want to maintain a database with up-to-date, reliable information.<\/p><p>As data quality is one of the biggest challenges facing data scientists, UPDATE is one of the <a href=\"https:\/\/datascientest.com\/en\/sql-queries-the-5-most-important-commands-to-know\">most common SQL queries.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-26c43fe e-flex e-con-boxed e-con\" data-id=\"26c43fe\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-20c8781 elementor-widget elementor-widget-heading\" data-id=\"20c8781\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I use the UPDATE SQL command?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-610e01a elementor-widget elementor-widget-text-editor\" data-id=\"610e01a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The<strong> syntax of the UPDATE SQL<\/strong> query is as follows:<\/p><p>UPDATE table name<br \/>SET column name = &#8216;new value<br \/><a href=\"https:\/\/datascientest.com\/en\/sql-where-heres-the-syntax\">WHERE condition<\/a><\/p><p>To better understand it, let&#8217;s take a look at its main attributes:<\/p><p>The SET clause: this defines what you&#8217;re going to replace existing data with. Here, only the columns to be modified need be specified. All other columns retain their current values.<br \/>The WHERE clause: this specifies where the changes are to be made.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d182712 elementor-widget elementor-widget-text-editor\" data-id=\"d182712\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Beyond this simplified syntax, it&#8217;s also possible to use the UPDATE function with other SQL queries, such as SELECT, <a href=\"https:\/\/datascientest.com\/en\/sql-insert-into-insert-data-with-this-sql-query\">INSERT INTO,<\/a> GETDATE, INNER, JOIN and so on. This allows you to enrich your database and perform more complex manipulations.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0490a76 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0490a76\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-scientist-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn how to use UPDATE SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-78f28a6 e-flex e-con-boxed e-con\" data-id=\"78f28a6\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-190e22b elementor-widget elementor-widget-heading\" data-id=\"190e22b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">5 examples of UPDATE queries<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f9b6222 elementor-widget elementor-widget-heading\" data-id=\"f9b6222\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Modify a line<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1ed840 elementor-widget elementor-widget-text-editor\" data-id=\"e1ed840\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>In this example, we use the Customer table below.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3f72064 elementor-widget elementor-widget-html\" data-id=\"3f72064\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 75px\">\n<col style=\"width: 75px\">\n<col style=\"width: 125px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">First name<\/th>\n    <th class=\"tg-a0vq\">Last name<\/th>\n    <th class=\"tg-a0vq\">City<\/th>\n    <th class=\"tg-a0vq\">E-mail<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-a0vq\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Paris<\/td>\n    <td class=\"tg-c3ow\">justinemartin@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">3<\/td>\n    <td class=\"tg-c3ow\">Marie<\/td>\n    <td class=\"tg-c3ow\">Leroy<\/td>\n    <td class=\"tg-c3ow\">Angers<\/td>\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">4<\/td>\n    <td class=\"tg-c3ow\">Vanessa<\/td>\n    <td class=\"tg-c3ow\">Savary<\/td>\n    <td class=\"tg-c3ow\">Marseille<\/td>\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e758367 elementor-widget elementor-widget-text-editor\" data-id=\"e758367\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Here, you want to update Justine Martin&#8217;s email address. Here&#8217;s her new address: justinemartin@sfr.fr. To do this, simply enter the following query:<\/p><p><br \/>UPDATE Customer<\/p><p><br \/>SET Email = &#8216;justinemartin@sfr.fr&#8217;<\/p><p><br \/>WHERE id = 1<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1658299 elementor-widget elementor-widget-text-editor\" data-id=\"1658299\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>And here&#8217;s the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fd3b961 elementor-widget elementor-widget-html\" data-id=\"fd3b961\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 75px\">\n<col style=\"width: 75px\">\n<col style=\"width: 125px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">First name<\/th>\n    <th class=\"tg-a0vq\">Last name<\/th>\n    <th class=\"tg-a0vq\">City<\/th>\n    <th class=\"tg-a0vq\">E-mail<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-a0vq\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Paris<\/td>\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">3<\/td>\n    <td class=\"tg-c3ow\">Marie<\/td>\n    <td class=\"tg-c3ow\">Leroy<\/td>\n    <td class=\"tg-c3ow\">Angers<\/td>\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">4<\/td>\n    <td class=\"tg-c3ow\">Vanessa<\/td>\n    <td class=\"tg-c3ow\">Savary<\/td>\n    <td class=\"tg-c3ow\">Marseille<\/td>\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b7597eb elementor-widget elementor-widget-heading\" data-id=\"b7597eb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Modify multiple data<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0987888 elementor-widget elementor-widget-text-editor\" data-id=\"0987888\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>If you wish to modify several pieces of information on the same line, simply separate the new values with a comma.<\/p><p>In our example, you&#8217;d like to change Not only Justine Martin&#8217;s email address, but also her city. She now lives in Nantes.<\/p><p><strong>Here&#8217;s the query:<\/strong><\/p><p>UPDATE Customer<\/p><p>SET<\/p><p>City = &#8216;Nantes&#8217;,<\/p><p>Email = &#8216;justinemartin@sfr.fr&#8217;<\/p><p>WHERE id = 1<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a28fd6 elementor-widget elementor-widget-text-editor\" data-id=\"0a28fd6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>And the new table:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a75f45 elementor-widget elementor-widget-html\" data-id=\"2a75f45\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 75px\">\n<col style=\"width: 75px\">\n<col style=\"width: 125px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">First name<\/th>\n    <th class=\"tg-a0vq\">Last name<\/th>\n    <th class=\"tg-a0vq\">City<\/th>\n    <th class=\"tg-a0vq\">E-mail<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-a0vq\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Nantes<\/td>\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">3<\/td>\n    <td class=\"tg-c3ow\">Marie<\/td>\n    <td class=\"tg-c3ow\">Leroy<\/td>\n    <td class=\"tg-c3ow\">Angers<\/td>\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">4<\/td>\n    <td class=\"tg-c3ow\">Vanessa<\/td>\n    <td class=\"tg-c3ow\">Savary<\/td>\n    <td class=\"tg-c3ow\">Marseille<\/td>\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0aabb45 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0aabb45\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn about SQL language<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-babe913 elementor-widget elementor-widget-heading\" data-id=\"babe913\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Modify all lines<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac23523 elementor-widget elementor-widget-text-editor\" data-id=\"ac23523\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>If you want to modify all the rows in the table, simply omit the WHERE query. For example, if all customers are moving to Lyon, here&#8217;s the query to save:<\/p><p>UPDATE Customer<\/p><p>SET<\/p><p>City = &#8216;Lyon<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38b9565 elementor-widget elementor-widget-text-editor\" data-id=\"38b9565\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>And the new table:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3609c6 elementor-widget elementor-widget-html\" data-id=\"a3609c6\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 75px\">\n<col style=\"width: 75px\">\n<col style=\"width: 125px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">First name<\/th>\n    <th class=\"tg-a0vq\">Last name<\/th>\n    <th class=\"tg-a0vq\">City<\/th>\n    <th class=\"tg-a0vq\">E-mail<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-a0vq\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Lyon<\/td>\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n    <td class=\"tg-c3ow\">Lyon<\/td>\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">3<\/td>\n    <td class=\"tg-c3ow\">Marie<\/td>\n    <td class=\"tg-c3ow\">Leroy<\/td>\n    <td class=\"tg-c3ow\">Lyon<\/td>\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">4<\/td>\n    <td class=\"tg-c3ow\">Vanessa<\/td>\n    <td class=\"tg-c3ow\">Savary<\/td>\n    <td class=\"tg-c3ow\">Lyon<\/td>\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6cf525e elementor-widget elementor-widget-heading\" data-id=\"6cf525e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Modify data from another table<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9e0cdea elementor-widget elementor-widget-text-editor\" data-id=\"9e0cdea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>For this example, we use two tables.<\/p><p>The first, &#8220;Products&#8221;, lists the products sold by a company and the salesperson who made the sale:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a3a87ea elementor-widget elementor-widget-html\" data-id=\"a3a87ea\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 150px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">Product<\/th>\n    <th class=\"tg-a0vq\">Price<\/th>\n    <th class=\"tg-a0vq\">Commercial ID<\/th>\n    <th class=\"tg-a0vq\">Salesperson name<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">Battery<\/td>\n    <td class=\"tg-c3ow\">100<\/td>\n    <td class=\"tg-c3ow\">5<\/td>\n    <td class=\"tg-c3ow\">NULL<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Telephone<\/td>\n    <td class=\"tg-c3ow\">300<\/td>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">NULL<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">Computer<\/td>\n    <td class=\"tg-c3ow\">800<\/td>\n    <td class=\"tg-c3ow\">3<\/td>\n    <td class=\"tg-c3ow\">NULL<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed6cb3a elementor-widget elementor-widget-text-editor\" data-id=\"ed6cb3a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The second &#8220;Employee&#8221; lists a company&#8217;s employees.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed705b4 elementor-widget elementor-widget-html\" data-id=\"ed705b4\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 325px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 150px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">Price<\/th>\n    <th class=\"tg-a0vq\">Commercial ID<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-c3ow\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas<\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-c3ow\">3<\/td>\n    <td class=\"tg-c3ow\">Marie<\/td>\n    <td class=\"tg-c3ow\">Leroy<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-baqh\">4<\/td>\n    <td class=\"tg-baqh\">Vanessa<\/td>\n    <td class=\"tg-baqh\">Savary<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-baqh\">5<\/td>\n    <td class=\"tg-baqh\">Jean<\/td>\n    <td class=\"tg-baqh\">Dupont<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-84422b0 elementor-widget elementor-widget-text-editor\" data-id=\"84422b0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The aim is to identify the name of the sales rep who made the sale, based on the sales rep&#8217;s ID. This name will then be integrated into the product table.<\/p><p><br \/>To achieve this, here&#8217;s the query to record:<\/p><p><br \/>UPDATE Product<\/p><p><br \/>SET Salesperson name = (SELECT &#8220;name&#8221; from &#8220;Employee&#8221; WHERE salesperson ID = ID)<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3d840ea elementor-widget elementor-widget-text-editor\" data-id=\"3d840ea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>And here is the result:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86f3227 elementor-widget elementor-widget-html\" data-id=\"86f3227\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 575px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 150px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">Product<\/th>\n    <th class=\"tg-a0vq\">Price<\/th>\n    <th class=\"tg-03gf\">Commercial ID<\/th>\n    <th class=\"tg-03gf\">Salesperson name<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-a0vq\">1<\/td>\n    <td class=\"tg-c3ow\">Battery<\/td>\n    <td class=\"tg-c3ow\">100<\/td>\n    <td class=\"tg-baqh\">5<\/td>\n    <td class=\"tg-baqh\">Dupont<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">2<\/td>\n    <td class=\"tg-c3ow\">Telephone<\/td>\n    <td class=\"tg-c3ow\">300<\/td>\n    <td class=\"tg-baqh\">1<\/td>\n    <td class=\"tg-baqh\">Martin<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">3<\/td>\n    <td class=\"tg-c3ow\">Computer<\/td>\n    <td class=\"tg-c3ow\">800<\/td>\n    <td class=\"tg-baqh\">3<\/td>\n    <td class=\"tg-baqh\">Leroy<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2cef172 elementor-widget elementor-widget-heading\" data-id=\"2cef172\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Update time with SQL UPDATE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d01f6af elementor-widget elementor-widget-text-editor\" data-id=\"d01f6af\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>You can also use the SQL query UPDATE with the GETDATE command to update the time and date.<\/p><p>For example, with this &#8220;Product&#8221; table, you&#8217;d like to update the purchase date of the products below to today&#8217;s date (04\/25\/2023).<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1f03a7c elementor-widget elementor-widget-html\" data-id=\"1f03a7c\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n.tg {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 425px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-a0vq\">ID<\/th>\n    <th class=\"tg-a0vq\">Product<\/th>\n    <th class=\"tg-a0vq\">Price<\/th>\n    <th class=\"tg-03gf\">Purchase date<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-a0vq\">1<\/td>\n    <td class=\"tg-c3ow\">Battery<\/td>\n    <td class=\"tg-c3ow\">100<\/td>\n    <td class=\"tg-baqh\">01\/03\/2023<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">2<\/td>\n    <td class=\"tg-c3ow\">Telephone<\/td>\n    <td class=\"tg-c3ow\">300<\/td>\n    <td class=\"tg-baqh\">06\/03\/2022<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-a0vq\">3<\/td>\n    <td class=\"tg-c3ow\">Computer<\/td>\n    <td class=\"tg-c3ow\">800<\/td>\n    <td class=\"tg-baqh\">15\/04\/2023<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d8859e2 elementor-widget elementor-widget-text-editor\" data-id=\"d8859e2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>To do this, enter the following query:<\/p><p>UPDATE Product<\/p><p>SET purchase date = GETDATE()<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f2787e6 elementor-widget elementor-widget-text-editor\" data-id=\"f2787e6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>The table is as follows:<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ebf12b8 elementor-widget elementor-widget-html\" data-id=\"ebf12b8\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\n  .tg  {border-collapse:collapse;border-spacing:0;}\n  .tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n    overflow:hidden;padding:10px 5px;word-break:normal;}\n  .tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n    font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n  .tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\n  .tg .tg-baqh{text-align:center;vertical-align:top}\n  .tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n  .tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 425px\">\n  <colgroup>\n    <col style=\"width: 25px\">\n    <col style=\"width: 125px\">\n    <col style=\"width: 125px\">\n    <col style=\"width: 150px\">\n  <\/colgroup>\n  <thead>\n    <tr>\n      <th class=\"tg-a0vq\">ID<\/th>\n      <th class=\"tg-a0vq\">Product<\/th>\n      <th class=\"tg-a0vq\">Price<\/th>\n      <th class=\"tg-03gf\">Purchase Date<\/th>\n    <\/tr>\n  <\/thead>\n  <tbody>\n    <tr>\n      <td class=\"tg-a0vq\">1<\/td>\n      <td class=\"tg-c3ow\">Battery<\/td>\n      <td class=\"tg-c3ow\">$100<\/td>\n      <td class=\"tg-baqh\">25\/04\/2023<\/td>\n    <\/tr>\n    <tr>\n      <td class=\"tg-a0vq\">2<\/td>\n      <td class=\"tg-c3ow\">Phone<\/td>\n      <td class=\"tg-c3ow\">$300<\/td>\n      <td class=\"tg-baqh\">25\/04\/2023<\/td>\n    <\/tr>\n    <tr>\n      <td class=\"tg-a0vq\">3<\/td>\n      <td class=\"tg-c3ow\">Computer<\/td>\n      <td class=\"tg-c3ow\">$800<\/td>\n      <td class=\"tg-baqh\">25\/04\/2023<\/td>\n    <\/tr>\n  <\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a59fc37 elementor-widget elementor-widget-text-editor\" data-id=\"a59fc37\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>As you can see, the SQL UPDATE query can be used in a multitude of ways. A single blog post may not be enough to cover the wide range of possible uses. If you&#8217;d like to find out more, don&#8217;t hesitate to join one of our training courses at DataScientest.<\/p><p>\u00a0<\/p><p>\ud83d\udca1Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL DELETE: How do I use this query?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\" target=\"_blank\" rel=\"noopener\">SQL DELETE: How do I use this query?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Developer: What is it? What's it for?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\" target=\"_blank\" rel=\"noopener\">SQL Developer: What is it? What&#8217;s it for?<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL Tutorial: Top 5 Most Useful Methods&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\" target=\"_blank\" rel=\"noopener\">SQL Tutorial: Top 5 Most Useful Methods<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL joins: everything you need to know about table associations&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\" target=\"_blank\" rel=\"noopener\">SQL joins: everything you need to know about table associations<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;SQL vs NoSQL: differences, uses, advantages and disadvantages&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/sql-vs-nosql\" target=\"_blank\" rel=\"noopener\">SQL vs NoSQL: differences, uses, advantages and disadvantages<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;NoSQL: All about non-relational databases&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\" target=\"_blank\" rel=\"noopener\">NoSQL: All about non-relational databases<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a23cf75 e-flex e-con-boxed e-con\" data-id=\"a23cf75\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-52e1e90 elementor-widget elementor-widget-heading\" data-id=\"52e1e90\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Expand your knowledge of SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c5f5c47 elementor-widget elementor-widget-text-editor\" data-id=\"c5f5c47\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>While SQL is the indispensable basis for manipulating relational databases, mastering it requires training and many hours of practice. That&#8217;s why we offer a range of training courses at DataScientest. Each course is tailored to your specific needs, either in terms of business or tools.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd841cb elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"cd841cb\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-scientist-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover DataScientest's SQL curriculum<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-980863e e-flex e-con-boxed e-con\" data-id=\"980863e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-af5296a elementor-widget elementor-widget-html\" data-id=\"af5296a\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is UPDATE SQL?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The SQL UPDATE command is used to update data within a table. This is essential if you want to maintain a database with up-to-date, reliable information. Since data quality is one of the biggest challenges facing data scientists, UPDATE is one of the most common SQL queries.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"How do I use the UPDATE SQL command?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"To understand it better, let's go back over its main attributes: The SET clause: this defines what you're going to replace existing data with. Here, only the columns to be modified need be specified. All other columns retain their current values. The WHERE clause: this is used to specify where the changes are to be made.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Because databases are constantly evolving, it&#8217;s essential to be familiar with the UPDATE SQL query. This allows you to modify one or more rows in your table. So how do you use it? We explain it all in this article. What is SQL UPDATE? The SQL UPDATE command is used to update data within a [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":175682,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL UPDATE: Update data with this command<\/title>\n<meta name=\"description\" content=\"Make sure to be cautious when using the SQL UPDATE statement, especially when it involves updating a large number of records or when there is\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL UPDATE: Update data with this command\" \/>\n<meta property=\"og:description\" content=\"Because databases are constantly evolving, it&#039;s essential to be familiar with the UPDATE SQL query. This allows you to modify one or more rows in your\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-04T17:07:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-04T17:14:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/update-sql-datascientest.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL UPDATE: Update data with this command\",\"datePublished\":\"2024-01-04T17:07:54+00:00\",\"dateModified\":\"2024-01-04T17:14:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command\"},\"wordCount\":870,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command\",\"url\":\"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command\",\"name\":\"SQL UPDATE: Update data with this command\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-04T17:07:54+00:00\",\"dateModified\":\"2024-01-04T17:14:32+00:00\",\"description\":\"Make sure to be cautious when using the SQL UPDATE statement, especially when it involves updating a large number of records or when there is\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL UPDATE: Update data with this command","description":"Make sure to be cautious when using the SQL UPDATE statement, especially when it involves updating a large number of records or when there is","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:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command","og_locale":"en_GB","og_type":"article","og_title":"SQL UPDATE: Update data with this command","og_description":"Because databases are constantly evolving, it's essential to be familiar with the UPDATE SQL query. This allows you to modify one or more rows in your","og_url":"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-04T17:07:54+00:00","article_modified_time":"2024-01-04T17:14:32+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/update-sql-datascientest.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL UPDATE: Update data with this command","datePublished":"2024-01-04T17:07:54+00:00","dateModified":"2024-01-04T17:14:32+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command"},"wordCount":870,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command","url":"https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command","name":"SQL UPDATE: Update data with this command","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-04T17:07:54+00:00","dateModified":"2024-01-04T17:14:32+00:00","description":"Make sure to be cautious when using the SQL UPDATE statement, especially when it involves updating a large number of records or when there is","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/sql-update-update-data-with-this-command"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175680"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=175680"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/175680\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/175682"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=175680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=175680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=175680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}