{"id":199621,"date":"2023-05-29T07:00:00","date_gmt":"2023-05-29T07:00:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=199621"},"modified":"2024-03-17T21:18:46","modified_gmt":"2024-03-17T21:18:46","slug":"update-sql-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/update-sql-tout-savoir","title":{"rendered":"UPDATE SQL : Mettre \u00e0 jour des donn\u00e9es gr\u00e2ce \u00e0 cette commande"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"199621\" class=\"elementor elementor-199621\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e985e85 e-flex e-con-boxed e-con\" data-id=\"e985e85\" 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-4988413 elementor-widget elementor-widget-heading\" data-id=\"4988413\" 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\">Parce que les bases de donn\u00e9es sont amen\u00e9es \u00e0 \u00e9voluer constamment, il est primordial de conna\u00eetre la requ\u00eate UPDATE SQL. Celle-ci vous permet de modifier une ou plusieurs lignes de votre tableau. Alors comment l\u2019utiliser ? On vous explique tout dans cet 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-b03d0f8 e-flex e-con-boxed e-con\" data-id=\"b03d0f8\" 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-2a6606f elementor-widget elementor-widget-heading\" data-id=\"2a6606f\" 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\">Qu'est-ce que UPDATE SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3968250 elementor-widget elementor-widget-text-editor\" data-id=\"3968250\" 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>La commande SQL UPDATE est utilis\u00e9e pour <strong>mettre \u00e0 jour des donn\u00e9es au sein d\u2019une table<\/strong>. C\u2019est indispensable si vous souhaitez conserver une base de donn\u00e9es avec des informations actuelles et fiables. <\/p><p>Comme la qualit\u00e9 des donn\u00e9es est l\u2019un des plus gros enjeux des <a href=\"https:\/\/datascientest.com\/quels-sont-les-metiers-de-la-data-les-mieux-payes-en-2023\">experts data<\/a>, UPDATE est l\u2019une des requ\u00eates les plus courantes dans le <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">langage SQL<\/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-1a20316 e-flex e-con-boxed e-con\" data-id=\"1a20316\" 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-f438be5 elementor-widget elementor-widget-heading\" data-id=\"f438be5\" 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\">Comment utiliser la commande UPDATE SQL ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e03bec elementor-widget elementor-widget-text-editor\" data-id=\"4e03bec\" 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>La syntaxe de la requ\u00eate UPDATE SQL est la suivante : <\/p><p style=\"padding-left: 40px;\">UPDATE nom de la table<br \/>SET nom de la colonne = &lsquo;nouvelle valeur&rsquo;<br \/>WHERE condition<\/p><p><span style=\"font-weight: 400;\">Pour mieux la comprendre, il convient de revenir sur ces principaux attributs, \u00e0 savoir :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>La clause SET :<\/b><span style=\"font-weight: 400;\"> cela permet de d\u00e9finir par quoi vous allez remplacer les donn\u00e9es existantes. Ici, seules les colonnes \u00e0 modifier doivent \u00eatre mentionn\u00e9es. Toutes les autres conservent leurs valeurs actuelles.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>La clause WHERE <\/b><span>: elle permet de sp\u00e9cifier o\u00f9 portent les modifications.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f5129fc elementor-widget elementor-widget-text-editor\" data-id=\"f5129fc\" 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>Au-del\u00e0 de cette syntaxe simplifi\u00e9e, il est aussi possible d\u2019<strong>utiliser la fonction UPDATE avec d\u2019autres requ\u00eates SQL<\/strong>, comme : SELECT, INSERT INTO, GETDATE, INNER, JOIN, etc. Cela permet ainsi d\u2019enrichir votre <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\">base de donn\u00e9es<\/a> et de r\u00e9aliser des manipulations plus complexes.<\/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-a69e394 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a69e394\" 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\/formation-sql\">\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\">Apprendre \u00e0 utiliser 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-d62b5af e-flex e-con-boxed e-con\" data-id=\"d62b5af\" 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-05ef70e elementor-widget elementor-widget-heading\" data-id=\"05ef70e\" 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 exemples d\u2019utilisation de la requ\u00eate UPDATE<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bae3400 elementor-widget elementor-widget-heading\" data-id=\"bae3400\" 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\">Modifier une ligne<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38532ba elementor-widget elementor-widget-text-editor\" data-id=\"38532ba\" 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>Dans cet exemple, nous utilisons le tableau Client ci-dessous.<\/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-749fa4e elementor-widget elementor-widget-html\" data-id=\"749fa4e\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-a0vq\">Nom<\/th>\r\n    <th class=\"tg-a0vq\">Ville<\/th>\r\n    <th class=\"tg-a0vq\">E-mail<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-c3ow\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n    <td class=\"tg-c3ow\">Angers<\/td>\r\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">4<\/td>\r\n    <td class=\"tg-c3ow\">Vanessa<\/td>\r\n    <td class=\"tg-c3ow\">Savary<\/td>\r\n    <td class=\"tg-c3ow\">Marseille<\/td>\r\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba21d5d elementor-widget elementor-widget-text-editor\" data-id=\"ba21d5d\" 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>Ici, vous souhaitez mettre \u00e0 jour l\u2019adresse email de Justine Martin. Voici sa nouvelle adresse : justinemartin@sfr.fr. Pour cela, il suffit de renseigner la requ\u00eate suivante :<\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">UPDATE Client<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SET Email = &lsquo;justinemartin@sfr.fr&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">WHERE id = 1<\/span><\/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-b3b3749 elementor-widget elementor-widget-text-editor\" data-id=\"b3b3749\" 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>Et voici le r\u00e9sultat :<\/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-e8587ec elementor-widget elementor-widget-html\" data-id=\"e8587ec\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-a0vq\">Nom<\/th>\r\n    <th class=\"tg-a0vq\">Ville<\/th>\r\n    <th class=\"tg-a0vq\">E-mail<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n    <td class=\"tg-c3ow\">Angers<\/td>\r\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">4<\/td>\r\n    <td class=\"tg-c3ow\">Vanessa<\/td>\r\n    <td class=\"tg-c3ow\">Savary<\/td>\r\n    <td class=\"tg-c3ow\">Marseille<\/td>\r\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c83125c elementor-widget elementor-widget-heading\" data-id=\"c83125c\" 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\">Modifier plusieurs donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3bce96a elementor-widget elementor-widget-text-editor\" data-id=\"3bce96a\" 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>Si vous souhaitez modifier plusieurs informations au sein d\u2019une m\u00eame ligne, il suffit de <strong>s\u00e9parer les nouvelles valeurs par une virgule<\/strong>.<\/p><p>Dans le cadre de notre exemple, vous souhaitez modifier l\u2019adresse email de Justine Martin, mais aussi sa ville. Elle habite d\u00e9sormais \u00e0 Nantes.<\/p><p>Voici la requ\u00eate :<\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">UPDATE Client<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SET\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">Ville = &lsquo;Nantes&rsquo;,<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">Email = &lsquo;justinemartin@sfr.fr&rsquo;<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">WHERE id = 1<\/span><\/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-657c918 elementor-widget elementor-widget-text-editor\" data-id=\"657c918\" 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>Et le nouveau tableau :<\/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-e2a3619 elementor-widget elementor-widget-html\" data-id=\"e2a3619\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-a0vq\">Nom<\/th>\r\n    <th class=\"tg-a0vq\">Ville<\/th>\r\n    <th class=\"tg-a0vq\">E-mail<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Nantes<\/td>\r\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n    <td class=\"tg-c3ow\">Angers<\/td>\r\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">4<\/td>\r\n    <td class=\"tg-c3ow\">Vanessa<\/td>\r\n    <td class=\"tg-c3ow\">Savary<\/td>\r\n    <td class=\"tg-c3ow\">Marseille<\/td>\r\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72516d9 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"72516d9\" 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\/formation-sql\">\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\">Se former au langage 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<div class=\"elementor-element elementor-element-91fd819 elementor-widget elementor-widget-heading\" data-id=\"91fd819\" 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\">Modifier toutes les lignes<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9909b71 elementor-widget elementor-widget-text-editor\" data-id=\"9909b71\" 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>Si vous souhaitez modifier toutes les lignes de la table, il suffit d\u2019<strong>omettre la requ\u00eate WHERE<\/strong>. Par exemple, si tous les clients d\u00e9m\u00e9nagent \u00e0 Lyon, voici la requ\u00eate \u00e0 enregistrer :<\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">UPDATE Client<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SET\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">Ville = &lsquo;Lyon&rsquo;<\/span><\/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-7ac6455 elementor-widget elementor-widget-text-editor\" data-id=\"7ac6455\" 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>Et le nouveau tableau :<\/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-a9df67c elementor-widget elementor-widget-html\" data-id=\"a9df67c\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 75px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-a0vq\">Nom<\/th>\r\n    <th class=\"tg-a0vq\">Ville<\/th>\r\n    <th class=\"tg-a0vq\">E-mail<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">justinemartin@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">4<\/td>\r\n    <td class=\"tg-c3ow\">Vanessa<\/td>\r\n    <td class=\"tg-c3ow\">Savary<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3ecafd4 elementor-widget elementor-widget-heading\" data-id=\"3ecafd4\" 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\">Modifier les donn\u00e9es \u00e0 partir des donn\u00e9es d\u2019un autre tableau<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f285466 elementor-widget elementor-widget-text-editor\" data-id=\"f285466\" 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>Pour cet exemple, nous utilisons deux tableaux. <\/p><p>Le premier \u00ab\u00a0Produits\u00a0\u00bb r\u00e9pertorie les produits vendus par une entreprise et le commercial ayant r\u00e9alis\u00e9 la vente :<\/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-4ec5efb elementor-widget elementor-widget-html\" data-id=\"4ec5efb\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">Produit<\/th>\r\n    <th class=\"tg-a0vq\">Prix<\/th>\r\n    <th class=\"tg-a0vq\">Commercial ID<\/th>\r\n    <th class=\"tg-a0vq\">Nom du commercial<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Batterie<\/td>\r\n    <td class=\"tg-c3ow\">100<\/td>\r\n    <td class=\"tg-c3ow\">5<\/td>\r\n    <td class=\"tg-c3ow\">NULL<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">T\u00e9l\u00e9phone<\/td>\r\n    <td class=\"tg-c3ow\">300<\/td>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">NULL<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">Ordinateur<\/td>\r\n    <td class=\"tg-c3ow\">800<\/td>\r\n    <td class=\"tg-c3ow\">3<\/td>\r\n    <td class=\"tg-c3ow\">NULL<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-682fb95 elementor-widget elementor-widget-text-editor\" data-id=\"682fb95\" 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>Le second \u00ab\u00a0Employ\u00e9\u00a0\u00bb r\u00e9pertorie les salari\u00e9s d\u2019une entreprise.<\/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-064e799 elementor-widget elementor-widget-html\" data-id=\"064e799\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 325px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 150px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Prix<\/th>\r\n    <th class=\"tg-a0vq\">Commercial ID<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas<\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-c3ow\">3<\/td>\r\n    <td class=\"tg-c3ow\">Marie<\/td>\r\n    <td class=\"tg-c3ow\">Leroy<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">4<\/td>\r\n    <td class=\"tg-baqh\">Vanessa<\/td>\r\n    <td class=\"tg-baqh\">Savary<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">5<\/td>\r\n    <td class=\"tg-baqh\">Jean<\/td>\r\n    <td class=\"tg-baqh\">Dupont<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d0860e7 elementor-widget elementor-widget-text-editor\" data-id=\"d0860e7\" 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>L\u2019objectif \u00e9tant d\u2019identifier le nom du commercial ayant r\u00e9alis\u00e9 la vente en fonction de son identifiant. Ce nom sera ensuite int\u00e9gr\u00e9 dans le tableau produit.<\/p><p>Pour cela, voici la requ\u00eate \u00e0 enregistrer : <\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">UPDATE Produit<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SET Nom du commercial = (SELECT \u201cnom\u201d from \u201cEmploy\u00e9\u201d WHERE commercial ID = ID)<\/span><\/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-1a6dded elementor-widget elementor-widget-text-editor\" data-id=\"1a6dded\" 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>Et voici le r\u00e9sultat :<\/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-4df8c30 elementor-widget elementor-widget-html\" data-id=\"4df8c30\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 575px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 150px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Produit<\/th>\r\n    <th class=\"tg-a0vq\">Prix<\/th>\r\n    <th class=\"tg-03gf\">Commercial ID<\/th>\r\n    <th class=\"tg-03gf\">Nom du commercial<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Batterie<\/td>\r\n    <td class=\"tg-c3ow\">100<\/td>\r\n    <td class=\"tg-baqh\">5<\/td>\r\n    <td class=\"tg-baqh\">Dupont<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">T\u00e9l\u00e9phone<\/td>\r\n    <td class=\"tg-c3ow\">300<\/td>\r\n    <td class=\"tg-baqh\">1<\/td>\r\n    <td class=\"tg-baqh\">Martin<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Ordinateur<\/td>\r\n    <td class=\"tg-c3ow\">800<\/td>\r\n    <td class=\"tg-baqh\">3<\/td>\r\n    <td class=\"tg-baqh\">Leroy<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9df3031 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"9df3031\" 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\/formation-sql\">\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\">D\u00e9couvrir notre formation 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<div class=\"elementor-element elementor-element-5581ba7 elementor-widget elementor-widget-heading\" data-id=\"5581ba7\" 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\">Actualiser l\u2019heure avec SQL UPDATE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-455f801 elementor-widget elementor-widget-text-editor\" data-id=\"455f801\" 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>Il est aussi possible d\u2019utiliser la requ\u00eate SQL UPDATE avec la commande <strong>GETDATE<\/strong> pour actualiser l\u2019heure et la date.<\/p><p>Par exemple, avec ce tableau \u00ab\u00a0Produit\u00a0\u00bb, vous souhaitez mettre \u00e0 jour la date d\u2019achat des produits ci-dessous avec la date d\u2019aujourd\u2019hui (25\/04\/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-e3fccba elementor-widget elementor-widget-html\" data-id=\"e3fccba\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 425px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Produit<\/th>\r\n    <th class=\"tg-a0vq\">Prix<\/th>\r\n    <th class=\"tg-03gf\">Date d'achat<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Batterie<\/td>\r\n    <td class=\"tg-c3ow\">100<\/td>\r\n    <td class=\"tg-baqh\">01\/03\/2023<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">T\u00e9l\u00e9phone<\/td>\r\n    <td class=\"tg-c3ow\">300<\/td>\r\n    <td class=\"tg-baqh\">06\/03\/2022<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Ordinateur<\/td>\r\n    <td class=\"tg-c3ow\">800<\/td>\r\n    <td class=\"tg-baqh\">15\/04\/2023<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef75e12 elementor-widget elementor-widget-text-editor\" data-id=\"ef75e12\" 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>Pour cela, il convient de renseigner la requ\u00eate suivante :<\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">UPDATE Produit<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"font-weight: 400;\">SET date d\u2019achat = GETDATE()<\/span><\/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-3667a84 elementor-widget elementor-widget-text-editor\" data-id=\"3667a84\" 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>Le tableau est le suivant : <\/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-da21405 elementor-widget elementor-widget-html\" data-id=\"da21405\" 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\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-03gf{background-color:#6665cd;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-a0vq{background-color:#6665cd;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 425px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-a0vq\">ID<\/th>\r\n    <th class=\"tg-a0vq\">Produit<\/th>\r\n    <th class=\"tg-a0vq\">Prix<\/th>\r\n    <th class=\"tg-03gf\">Date d'achat<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">1<\/td>\r\n    <td class=\"tg-c3ow\">Batterie<\/td>\r\n    <td class=\"tg-c3ow\">100<\/td>\r\n    <td class=\"tg-baqh\">25\/04\/2023<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">2<\/td>\r\n    <td class=\"tg-c3ow\">T\u00e9l\u00e9phone<\/td>\r\n    <td class=\"tg-c3ow\">300<\/td>\r\n    <td class=\"tg-baqh\">25\/04\/2023<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-a0vq\">3<\/td>\r\n    <td class=\"tg-c3ow\">Ordinateur<\/td>\r\n    <td class=\"tg-c3ow\">800<\/td>\r\n    <td class=\"tg-baqh\">25\/04\/2023<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-611383d elementor-widget elementor-widget-text-editor\" data-id=\"611383d\" 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>Vous l\u2019aurez compris, il est possible d\u2019utiliser la <strong>requ\u00eate SQL UPDATE<\/strong> d\u2019une multitude de mani\u00e8res. La r\u00e9daction d\u2019un simple article de blog semble insuffisante pour parcourir la grande diversit\u00e9 des utilisations possibles. Si vous souhaitez en savoir plus, n\u2019h\u00e9sitez pas \u00e0 <strong>rejoindre l\u2019une de nos formations chez DataScientest<\/strong>. <\/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-5c344f0 e-flex e-con-boxed e-con\" data-id=\"5c344f0\" 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-f0a85db elementor-widget elementor-widget-heading\" data-id=\"f0a85db\" 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\">D\u00e9veloppez vos connaissances du langage SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-64952e4 elementor-widget elementor-widget-text-editor\" data-id=\"64952e4\" 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>Si le langage SQL constitue la base indispensable pour manipuler des bases de donn\u00e9es relationnelles, sa ma\u00eetrise n\u00e9cessite une formation avec plusieurs heures de pratique. C\u2019est justement pour cette raison que <strong>nous vous proposons diff\u00e9rentes formations chez DataScientest<\/strong>. Chacune \u00e9tant orient\u00e9e m\u00e9tier ou outils, vous <strong>d\u00e9velopperez vos comp\u00e9tences du langage SQL<\/strong> en fonction de vos besoins sp\u00e9cifiques. <\/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-0daafc4 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0daafc4\" 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\/formation-sql\">\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\">D\u00e9couvrir le cursus SQL de DataScientest<\/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-b5fc147 e-flex e-con-boxed e-con\" data-id=\"b5fc147\" 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-52958df elementor-widget elementor-widget-html\" data-id=\"52958df\" 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\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est-ce que UPDATE SQL ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La commande SQL UPDATE est utilis\u00e9e pour mettre \u00e0 jour des donn\u00e9es au sein d\u2019une table. C\u2019est indispensable si vous souhaitez conserver une base de donn\u00e9es avec des informations actuelles et fiables. Comme la qualit\u00e9 des donn\u00e9es est l\u2019un des plus gros enjeux des experts data, UPDATE est l\u2019une des requ\u00eates les plus courantes dans le langage SQL.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment utiliser la commande UPDATE SQL ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Pour mieux la comprendre, il convient de revenir sur ces principaux attributs, \u00e0 savoir : La clause SET : cela permet de d\u00e9finir par quoi vous allez remplacer les donn\u00e9es existantes. Ici, seules les colonnes \u00e0 modifier doivent \u00eatre mentionn\u00e9es. Toutes les autres conservent leurs valeurs actuelles. La clause WHERE : elle permet de sp\u00e9cifier o\u00f9 portent les modifications.\"\r\n    }\r\n  }]\r\n}\r\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>Parce que les bases de donn\u00e9es sont amen\u00e9es \u00e0 \u00e9voluer constamment, il est primordial de conna\u00eetre la requ\u00eate UPDATE SQL. Celle-ci vous permet de modifier une ou plusieurs lignes de votre tableau. Alors comment l\u2019utiliser ? On vous explique tout dans cet article. Qu&rsquo;est-ce que UPDATE SQL ? La commande SQL UPDATE est utilis\u00e9e pour [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":199627,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"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>UPDATE SQL : Mettre \u00e0 jour des donn\u00e9es gr\u00e2ce \u00e0 cette commande<\/title>\n<meta name=\"description\" content=\"Pour actualiser votre base de donn\u00e9es, utilisez la commande UPDATE SQL. D\u00e9couvrez son fonctionnement.\" \/>\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\/update-sql-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"UPDATE SQL : Mettre \u00e0 jour des donn\u00e9es gr\u00e2ce \u00e0 cette commande\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/update-sql-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-29T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-17T21:18:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/update-sql-datascientest.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/update-sql-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/update-sql-tout-savoir\",\"name\":\"UPDATE SQL : Mettre \u00e0 jour des donn\u00e9es gr\u00e2ce \u00e0 cette commande\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-05-29T07:00:00+00:00\",\"dateModified\":\"2024-03-17T21:18:46+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"Pour actualiser votre base de donn\u00e9es, utilisez la commande UPDATE SQL. D\u00e9couvrez son fonctionnement.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/update-sql-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"UPDATE SQL : Mettre \u00e0 jour des donn\u00e9es gr\u00e2ce \u00e0 cette commande","description":"Pour actualiser votre base de donn\u00e9es, utilisez la commande UPDATE SQL. D\u00e9couvrez son fonctionnement.","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\/update-sql-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"UPDATE SQL : Mettre \u00e0 jour des donn\u00e9es gr\u00e2ce \u00e0 cette commande","og_url":"https:\/\/datascientest.com\/update-sql-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-05-29T07:00:00+00:00","article_modified_time":"2024-03-17T21:18:46+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/update-sql-datascientest.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/update-sql-tout-savoir","url":"https:\/\/datascientest.com\/update-sql-tout-savoir","name":"UPDATE SQL : Mettre \u00e0 jour des donn\u00e9es gr\u00e2ce \u00e0 cette commande","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-05-29T07:00:00+00:00","dateModified":"2024-03-17T21:18:46+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"Pour actualiser votre base de donn\u00e9es, utilisez la commande UPDATE SQL. D\u00e9couvrez son fonctionnement.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/update-sql-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/199621"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=199621"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/199621\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/199627"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=199621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=199621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=199621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}