{"id":199726,"date":"2023-06-02T07:00:00","date_gmt":"2023-06-02T07:00:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=199726"},"modified":"2023-11-09T13:52:16","modified_gmt":"2023-11-09T13:52:16","slug":"insert-into-sql-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/insert-into-sql-tout-savoir","title":{"rendered":"INSERT INTO : Ins\u00e9rer des donn\u00e9es avec cette requ\u00eate SQL"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"199726\" class=\"elementor elementor-199726\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2bcc13c e-flex e-con-boxed e-con\" data-id=\"2bcc13c\" 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-6b090eb elementor-widget elementor-widget-heading\" data-id=\"6b090eb\" 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\">Pour ins\u00e9rer les donn\u00e9es au sein de votre table SQL, il est possible d\u2019utiliser la requ\u00eate INSERT INTO. Mais alors comment \u00e7a fonctionne ? C\u2019est ce que nous allons voir 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-52eef44 e-flex e-con-boxed e-con\" data-id=\"52eef44\" 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-f6a89e0 elementor-widget elementor-widget-heading\" data-id=\"f6a89e0\" 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 la requ\u00eate INSERT INTO ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ca2715 elementor-widget elementor-widget-text-editor\" data-id=\"0ca2715\" 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>INSERT INTO est l\u2019une des commandes les plus couramment utilis\u00e9es dans le langage SQL. Et pour cause, cette requ\u00eate vous permet <strong>d\u2019int\u00e9grer de nouveaux enregistrements au sein de votre base de donn\u00e9es<\/strong>. Il peut s\u2019agir d\u2019une ou plusieurs lignes en fonction de vos besoins.<\/p><p><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir :<\/strong><\/span> INSERT INTO est la commande \u00e0 utiliser pour tous les syst\u00e8mes de <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\">gestion de bases de donn\u00e9es<\/a>. Et ce, que vous utilisiez Oracle, <a href=\"https:\/\/datascientest.com\/mysql-tout-comprendre\">Mysql<\/a>, Transact-SQL, etc. <\/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-592d1a0 e-flex e-con-boxed e-con\" data-id=\"592d1a0\" 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-fbe6e0a elementor-widget elementor-widget-heading\" data-id=\"fbe6e0a\" 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 requ\u00eate SQL INSERT INTO ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aae9cca elementor-widget elementor-widget-text-editor\" data-id=\"aae9cca\" 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>INSERT INTO peut \u00eatre utilis\u00e9 pour int\u00e9grer une ou plusieurs lignes au sein de votre tableau. Mais il est \u00e9galement possible d\u2019utiliser cette commande dans des requ\u00eates plus complexes. Dans cet article, nous vous pr\u00e9sentons diff\u00e9rents cas d\u2019application.<\/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-b3853e3 elementor-widget elementor-widget-heading\" data-id=\"b3853e3\" 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\">Ins\u00e9rer une ligne<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-578fad0 elementor-widget elementor-widget-text-editor\" data-id=\"578fad0\" 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, deux possibilit\u00e9s s\u2019offrent \u00e0 vous.<\/p><p><strong>1\u00ba Il est possible d\u2019ins\u00e9rer une ligne en sp\u00e9cifiant toutes les colonnes.<\/strong> Dans ce cadre, la syntaxe est la suivante : <\/p><p style=\"padding-left: 40px;\">INSERT INTO table VALUES (&lsquo;valeur 1&rsquo;, &lsquo;valeur 2&rsquo;, &#8230;)<\/p><p>Si vous choisissez cette option, veillez \u00e0 bien respecter l\u2019ordre des colonnes. Et pour cause, le syst\u00e8me de gestion de base de donn\u00e9es interpr\u00e8te les requ\u00eates SQL selon les informations que vous lui donnez. Donc si vous n\u2019avez pas besoin d\u2019enregistrer de nouvelles valeurs pour certaines colonnes, il faudra pr\u00e9ciser la mention \u00ab\u00a0NULL\u00a0\u00bb (au lieu de valeur 1,2\u2026). <\/p><p>L\u2019avantage, c\u2019est qu\u2019il n\u2019y a pas besoin d\u2019\u00e9crire le nom de chaque limite. Ce qui limite fortement les fautes de frappe.<\/p><p><strong>2\u00ba Vous pouvez pr\u00e9ciser uniquement les colonnes pour lesquelles vous souhaitez int\u00e9grer de nouvelles donn\u00e9es.<\/strong> Pour cela, vous devez utiliser la syntaxe suivante : <\/p><p style=\"padding-left: 40px;\">INSERT INTO table (nom-de-colonne_1, nom-de-colonne_2, \u2026)<br \/>VALUES (&lsquo;valeur 1&rsquo;, &lsquo;valeur 2&rsquo;, &#8230;)<\/p><p>Ici, l\u2019ordre des colonnes n\u2019est plus aussi important. Attention toutefois, \u00e0 l\u2019ordre des valeurs. Celles-ci doivent correspondre aux colonnes auxquelles elles sont assign\u00e9es. <\/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-d8038fe elementor-widget elementor-widget-heading\" data-id=\"d8038fe\" 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\">Ins\u00e9rer plusieurs lignes<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1ae6e1b elementor-widget elementor-widget-text-editor\" data-id=\"1ae6e1b\" 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&rsquo;insertion de plusieurs lignes est souvent n\u00e9cessaire pour enrichir votre tableau. <\/p><p>Pour vous aider \u00e0 mieux comprendre, nous vous proposons l\u2019exemple concret d\u2019un fichier Client auquel vous souhaitez ajouter les coordonn\u00e9es de plusieurs clients. <\/p><p>Voici la requ\u00eate : <\/p><p style=\"padding-left: 40px;\">INSERT INTO client (pr\u00e9nom, nom, ville, email)<br \/>VALUES<br \/>(&lsquo;Justine&rsquo;, &lsquo;Martin&rsquo;, &lsquo;Paris&rsquo;, &lsquo;justinemartin@gmail.com&rsquo; ),<br \/>(&lsquo;Thomas&rsquo;, &lsquo;Durant&rsquo;, &lsquo;Bordeaux&rsquo;, &lsquo;tomtom@sfr.fr&rsquo;),<br \/>(&lsquo;Marie&rsquo;, &lsquo;Leroy&rsquo;, &lsquo;Angers&rsquo;,&rsquo;marieleroy@laposte.net&rsquo;),<br \/>(&lsquo;Vanessa&rsquo;, &lsquo;Savary&rsquo;, &lsquo;Marseille&rsquo;, &lsquo;vanessa13@gmail.com&rsquo;)<\/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-989f0d1 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"989f0d1\" 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 INSERT INTO<\/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-6623da8 elementor-widget elementor-widget-text-editor\" data-id=\"6623da8\" 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>Gr\u00e2ce \u00e0 la commande INSERT INTO, vous pourrez int\u00e9grer les donn\u00e9es suivantes au sein de votre 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-2481c1a elementor-widget elementor-widget-html\" data-id=\"2481c1a\" 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-8806{background-color:#6434fc;border-color:inherit;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-mw77{background-color:#6434fc;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: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Nom<\/th>\r\n    <th class=\"tg-8806\">Ville<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\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-baqh\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\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-baqh\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Marie<\/td>\r\n    <td class=\"tg-baqh\">Leroy<\/td>\r\n    <td class=\"tg-baqh\">Angers<\/td>\r\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Vanessa<\/td>\r\n    <td class=\"tg-baqh\">Savary<\/td>\r\n    <td class=\"tg-baqh\">Marseille<\/td>\r\n    <td class=\"tg-baqh\">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-1d52c8f elementor-widget elementor-widget-heading\" data-id=\"1d52c8f\" 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\">Copier 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-9314902 elementor-widget elementor-widget-text-editor\" data-id=\"9314902\" 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>En combinant plusieurs requ\u00eates, vous pouvez \u00e9galement copier les donn\u00e9es d\u2019un tableau A vers un tableau. <\/p><p>Pour cela, il vous faudra utiliser la syntaxe suivante : <\/p><p style=\"padding-left: 40px;\">INSERT INTO ma_table_1 SELECT colonne_1,colonne_2,colonne_2 FROM ma_table_2 WHERE conditions<\/p><p>Prenons un exemple : <\/p><p>Vous avez deux tableaux. Le premier correspond \u00e0 un fichier \u00ab\u00a0client\u00a0\u00bb : <\/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-98177e5 elementor-widget elementor-widget-html\" data-id=\"98177e5\" 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-8806{background-color:#6434fc;border-color:inherit;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-mw77{background-color:#6434fc;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: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Nom<\/th>\r\n    <th class=\"tg-8806\">Ville<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\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-baqh\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\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-baqh\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Marie<\/td>\r\n    <td class=\"tg-baqh\">Leroy<\/td>\r\n    <td class=\"tg-baqh\">Angers<\/td>\r\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-baqh\">Vanessa<\/td>\r\n    <td class=\"tg-baqh\">Savary<\/td>\r\n    <td class=\"tg-baqh\">Marseille<\/td>\r\n    <td class=\"tg-baqh\">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-897ea80 elementor-widget elementor-widget-text-editor\" data-id=\"897ea80\" 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 second, \u00e0 un fichier de \u00ab\u00a0Prospection\u00a0\u00bb :<\/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-c95d1b9 elementor-widget elementor-widget-html\" data-id=\"c95d1b9\" 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-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 525px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">ID<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Nom<\/th>\r\n    <th class=\"tg-8806\">Ville<\/th>\r\n    <th class=\"tg-8806\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-8806\">1<\/td>\r\n    <td class=\"tg-c3ow\">Jean<\/td>\r\n    <td class=\"tg-c3ow\">Bernad<\/td>\r\n    <td class=\"tg-c3ow\">Valenciennes<\/td>\r\n    <td class=\"tg-c3ow\">jbernard@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-8806\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas <\/td>\r\n    <td class=\"tg-c3ow\">Castaing<\/td>\r\n    <td class=\"tg-c3ow\">Nantes<\/td>\r\n    <td class=\"tg-c3ow\">thomas.castaing@orange.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-8806\">3<\/td>\r\n    <td class=\"tg-c3ow\">Antoine<\/td>\r\n    <td class=\"tg-c3ow\">Dupond<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-c3ow\">Antwan@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-8806\">4<\/td>\r\n    <td class=\"tg-c3ow\">Virginie<\/td>\r\n    <td class=\"tg-c3ow\">Pavard<\/td>\r\n    <td class=\"tg-c3ow\">Lyon<\/td>\r\n    <td class=\"tg-c3ow\">V.pavard@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-7315683 elementor-widget elementor-widget-text-editor\" data-id=\"7315683\" 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>Ayant converti un prospect (Jean Bernard), vous souhaitez le transf\u00e9rer dans votre fichier client.<\/p><p>Voici la requ\u00eate : <\/p><p style=\"padding-left: 40px;\">INSERT INTO Client SELECT (pr\u00e9nom, nom, ville, email) FROM prospection WHERE id = 1<\/p><p>Et 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-2a0396e elementor-widget elementor-widget-html\" data-id=\"2a0396e\" 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-8806{background-color:#6434fc;border-color:inherit;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<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\r\n<colgroup>\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 150px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Nom<\/th>\r\n    <th class=\"tg-8806\">Ville<\/th>\r\n    <th class=\"tg-8806\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\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-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-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-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  <tr>\r\n    <td class=\"tg-baqh\">Jean<\/td>\r\n    <td class=\"tg-baqh\">Bernard<\/td>\r\n    <td class=\"tg-baqh\">Valenciennes<\/td>\r\n    <td class=\"tg-baqh\">jbernard@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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a4bf899 e-flex e-con-boxed e-con\" data-id=\"a4bf899\" 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-85c027d elementor-widget elementor-widget-heading\" data-id=\"85c027d\" 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 comp\u00e9tences en langage SQL avec DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-902d464 elementor-widget elementor-widget-text-editor\" data-id=\"902d464\" 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 <strong>manipulation des donn\u00e9es relationnelles<\/strong> ne passe pas seulement par l\u2019ajout de nouvelles informations. Il est possible d\u2019en supprimer, d\u2019en modifier, d\u2019en actualiser, etc. Pour toutes ces actions, il existe une multitude de <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">requ\u00eates SQL<\/a>. Si vous souhaitez toutes les conna\u00eetre, une formation data est plus que n\u00e9cessaire. C\u2019est justement pour cette raison que nous avons d\u00e9velopp\u00e9 DataScientest. Nous vous proposons plusieurs <a href=\"https:\/\/datascientest.com\/formations-data\">formations orient\u00e9es m\u00e9tiers<\/a> afin de vous aider \u00e0 d\u00e9velopper vos comp\u00e9tences.<\/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-988e1ab elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"988e1ab\" 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\u00e9marrer une 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\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b07dfb1 e-flex e-con-boxed e-con\" data-id=\"b07dfb1\" 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-b35db4c elementor-widget elementor-widget-html\" data-id=\"b35db4c\" 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>Pour ins\u00e9rer les donn\u00e9es au sein de votre table SQL, il est possible d\u2019utiliser la requ\u00eate INSERT INTO. Mais alors comment \u00e7a fonctionne ? C\u2019est ce que nous allons voir dans cet article. Qu&rsquo;est-ce que la requ\u00eate INSERT INTO ? INSERT INTO est l\u2019une des commandes les plus couramment utilis\u00e9es dans le langage SQL. Et [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":199741,"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>INSERT INTO : Ins\u00e9rer des donn\u00e9es avec cette requ\u00eate SQL<\/title>\n<meta name=\"description\" content=\"Pour actualiser votre base de donn\u00e9es et ajouter de nouvelles informations, vous aurez besoin de la requ\u00eate INSERT INTO.\" \/>\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\/insert-into-sql-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"INSERT INTO : Ins\u00e9rer des donn\u00e9es avec cette requ\u00eate SQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/insert-into-sql-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-02T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:52:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/sql-insert-into-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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/insert-into-sql-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/insert-into-sql-tout-savoir\",\"name\":\"INSERT INTO : Ins\u00e9rer des donn\u00e9es avec cette requ\u00eate SQL\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-06-02T07:00:00+00:00\",\"dateModified\":\"2023-11-09T13:52:16+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"Pour actualiser votre base de donn\u00e9es et ajouter de nouvelles informations, vous aurez besoin de la requ\u00eate INSERT INTO.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/insert-into-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":"INSERT INTO : Ins\u00e9rer des donn\u00e9es avec cette requ\u00eate SQL","description":"Pour actualiser votre base de donn\u00e9es et ajouter de nouvelles informations, vous aurez besoin de la requ\u00eate INSERT INTO.","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\/insert-into-sql-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"INSERT INTO : Ins\u00e9rer des donn\u00e9es avec cette requ\u00eate SQL","og_url":"https:\/\/datascientest.com\/insert-into-sql-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-06-02T07:00:00+00:00","article_modified_time":"2023-11-09T13:52:16+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/sql-insert-into-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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/insert-into-sql-tout-savoir","url":"https:\/\/datascientest.com\/insert-into-sql-tout-savoir","name":"INSERT INTO : Ins\u00e9rer des donn\u00e9es avec cette requ\u00eate SQL","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-06-02T07:00:00+00:00","dateModified":"2023-11-09T13:52:16+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"Pour actualiser votre base de donn\u00e9es et ajouter de nouvelles informations, vous aurez besoin de la requ\u00eate INSERT INTO.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/insert-into-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\/199726"}],"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=199726"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/199726\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/199741"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=199726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=199726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=199726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}