{"id":176446,"date":"2024-01-16T14:05:17","date_gmt":"2024-01-16T13:05:17","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=176446"},"modified":"2024-01-16T14:06:45","modified_gmt":"2024-01-16T13:06:45","slug":"insert-into-sql-insert-data-with-this-sql-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query","title":{"rendered":"INSERT INTO SQL: Insert data with this SQL query"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"176446\" class=\"elementor elementor-176446\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-07891cd e-flex e-con-boxed e-con\" data-id=\"07891cd\" 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-d1ca0ee elementor-widget elementor-widget-heading\" data-id=\"d1ca0ee\" 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\">To insert data into your SQL table, you can use the INSERT INTOSQL query. But how does it work? That's what we're going to look at 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-d8c2d37 e-flex e-con-boxed e-con\" data-id=\"d8c2d37\" 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-dd853b4 elementor-widget elementor-widget-heading\" data-id=\"dd853b4\" 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 an INSERT INTO SQL request?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ba39edd elementor-widget elementor-widget-text-editor\" data-id=\"ba39edd\" 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><strong>INSERT INTO SQL<\/strong> is one of the most commonly used commands in the <a href=\"https:\/\/datascientest.com\/en\/sql-queries-the-5-most-important-commands-to-know\">SQL language<\/a>. And with good reason: this query allows you to integrate new records into your database. This can be one or more rows, depending on your needs.<\/p><p>Good to know:<strong> INSERT INTO SQL<\/strong> is the command to use for all <a href=\"https:\/\/datascientest.com\/en\/acid-in-database-management\">database management<\/a> systems. Whether you&#8217;re <a href=\"https:\/\/datascientest.com\/en\/oracle-the-challenger-rivaling-azure-aws-and-google-cloud\">using Oracle<\/a>, Mysql, 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-2ad9877 e-flex e-con-boxed e-con\" data-id=\"2ad9877\" 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-68e6058 elementor-widget elementor-widget-heading\" data-id=\"68e6058\" 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 SQL query INSERT INTO?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c395985 elementor-widget elementor-widget-text-editor\" data-id=\"c395985\" 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><strong>INSERT INTO SQL<\/strong> can be used to insert one or more rows into your table. But it&#8217;s also possible to use this command in more complex queries. In this article, we&#8217;ll take a look at some of these applications.<\/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-7a098ba elementor-widget elementor-widget-heading\" data-id=\"7a098ba\" 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\">Insert a line<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dcd98ac elementor-widget elementor-widget-text-editor\" data-id=\"dcd98ac\" 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>There are two ways of doing this.<\/p><p><strong>1\u00ba<\/strong> You can insert a line by specifying all the columns. In this case, the syntax is as follows:<\/p><p>INSERT INTO table VALUES (&#8216;value 1&#8217;, &#8216;value 2&#8217;, &#8230;)<\/p><p>If you choose this option, be sure to respect the order of the columns. The database management system interprets SQL queries according to the information you give it. So if you don&#8217;t need to record new values for certain columns, you&#8217;ll need to specify &#8220;NULL&#8221; (instead of value 1,2&#8230;).<\/p><p>The advantage is that you don&#8217;t need to write the name of each limit. This greatly reduces typing errors.<\/p><p><strong>2\u00ba<\/strong> You can specify only those columns for which you wish to integrate new data. To do this, use the following syntax:<\/p><p>INSERT INTO table (column-name_1, column-name_2, &#8230;)<br \/>VALUES (&#8216;value 1&#8217;, &#8216;value 2&#8217;, &#8230;)<\/p><p>Here, column order is no longer as important. Be careful, however, with the order of values. They must correspond to the columns to which they are assigned.<\/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-f45ca8a elementor-widget elementor-widget-heading\" data-id=\"f45ca8a\" 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\">Insert several lines<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1772987 elementor-widget elementor-widget-text-editor\" data-id=\"1772987\" 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>It is often necessary to insert several lines to enrich your table.<\/p><p>To help you understand, here&#8217;s a concrete example of a Customer file to which you want to add the contact details of several customers.<\/p><p>Here&#8217;s the query:<\/p><p>INSERT INTO customer (first name, last name, city, email)<br \/>VALUES<br \/>(&#8216;Justine&#8217;, &#8216;Martin&#8217;, &#8216;Paris&#8217;, &#8216;justinemartin@gmail.com&#8217; ),<br \/>(&#8216;Thomas&#8217;, &#8216;Durant&#8217;, &#8216;Bordeaux&#8217;, &#8216;tomtom@sfr.fr&#8217;),<br \/>(&#8216;Marie&#8217;, &#8216;Leroy&#8217;, &#8216;Angers&#8217;, &#8216;marieleroy@laposte.net&#8217;),<br \/>(&#8216;Vanessa&#8217;, &#8216;Savary&#8217;, &#8216;Marseille&#8217;, &#8216;vanessa13@gmail.com&#8217;)<\/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-bf44d4b elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"bf44d4b\" 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 how to use 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-2938c50 elementor-widget elementor-widget-text-editor\" data-id=\"2938c50\" 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>Use the INSERT INTO command to integrate the following data into your 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-54e6298 elementor-widget elementor-widget-html\" data-id=\"54e6298\" 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-8806{background-color:#6434fc;border-color:inherit;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-mw77{background-color:#6434fc;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: 125px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">City<\/th>\n    <th class=\"tg-mw77\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\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-baqh\">justinemartin@gmail.com<\/td>\n  <\/tr>\n  <tr>\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-baqh\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-baqh\">Marie<\/td>\n    <td class=\"tg-baqh\">Leroy<\/td>\n    <td class=\"tg-baqh\">Angers<\/td>\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-baqh\">Vanessa<\/td>\n    <td class=\"tg-baqh\">Savary<\/td>\n    <td class=\"tg-baqh\">Marseille<\/td>\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/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-4aea1ae elementor-widget elementor-widget-heading\" data-id=\"4aea1ae\" 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\">Copy 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-4eace1f elementor-widget elementor-widget-text-editor\" data-id=\"4eace1f\" 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>By combining several queries, you can also copy data from an A array to a table.<\/p><p>To do this, use the following syntax:<\/p><p>INSERT INTO my_table_1 SELECT column_1,column_2,column_2 FROM my_table_2 WHERE conditions<\/p><p>Let&#8217;s take an example:<\/p><p>You have two tables. The first corresponds to a &#8220;customer&#8221; file:<\/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-7c27d8f elementor-widget elementor-widget-html\" data-id=\"7c27d8f\" 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-d7025dc elementor-widget elementor-widget-text-editor\" data-id=\"d7025dc\" 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 second, to a &#8220;Prospecting&#8221; file:<\/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-8543205 elementor-widget elementor-widget-html\" data-id=\"8543205\" 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-8806{background-color:#6434fc;border-color:inherit;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-mw77{background-color:#6434fc;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: 125px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">City<\/th>\n    <th class=\"tg-mw77\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\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-baqh\">justinemartin@gmail.com<\/td>\n  <\/tr>\n  <tr>\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-baqh\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-baqh\">Marie<\/td>\n    <td class=\"tg-baqh\">Leroy<\/td>\n    <td class=\"tg-baqh\">Angers<\/td>\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-baqh\">Vanessa<\/td>\n    <td class=\"tg-baqh\">Savary<\/td>\n    <td class=\"tg-baqh\">Marseille<\/td>\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/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-7585984 elementor-widget elementor-widget-text-editor\" data-id=\"7585984\" 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>Having converted a prospect (Jean Bernard), you want to transfer him to your customer file.<\/p><p>Here&#8217;s the query:<\/p><p>INSERT INTO Customer SELECT (first name, last name, city, email) FROM prospect WHERE id = 1<\/p><p>And 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-e6f5142 elementor-widget elementor-widget-html\" data-id=\"e6f5142\" 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-8806{background-color:#6434fc;border-color:inherit;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<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 500px\">\n<colgroup>\n<col style=\"width: 125px\">\n<col style=\"width: 100px\">\n<col style=\"width: 100px\">\n<col style=\"width: 150px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">First Name<\/th>\n    <th class=\"tg-8806\">Last Name<\/th>\n    <th class=\"tg-8806\">City<\/th>\n    <th class=\"tg-8806\">Email<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\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-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-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-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  <tr>\n    <td class=\"tg-baqh\">Jean<\/td>\n    <td class=\"tg-baqh\">Bernard<\/td>\n    <td class=\"tg-baqh\">Valenciennes<\/td>\n    <td class=\"tg-baqh\">jbernard@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\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-e976630 e-flex e-con-boxed e-con\" data-id=\"e976630\" 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-60f88ca elementor-widget elementor-widget-heading\" data-id=\"60f88ca\" 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\">Develop your SQL skills with DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a2ea1d3 elementor-widget elementor-widget-text-editor\" data-id=\"a2ea1d3\" 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>Manipulating relational data doesn&#8217;t just mean adding new information. It&#8217;s also possible to delete, modify, update and so on.<\/p><p>For all these actions, there are a multitude of <a href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\">SQL queries<\/a>. If you want to know them all, data training is more than necessary. That&#8217;s why we&#8217;ve developed DataScientest.<\/p><p>We offer a range of industry-specific training courses to help you<strong> develop your skills.<\/strong><\/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-ca35041 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"ca35041\" 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\">Start your SQL training <\/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-4f937f8 e-flex e-con-boxed e-con\" data-id=\"4f937f8\" 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-3ddfe55 elementor-widget elementor-widget-text-editor\" data-id=\"3ddfe55\" 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><strong>\ud83d\udca1 Related articles:\u00a0<\/strong><\/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<div class=\"elementor-element elementor-element-70d0acb elementor-widget elementor-widget-html\" data-id=\"70d0acb\" 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. As 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>To insert data into your SQL table, you can use the INSERT INTOSQL query. But how does it work? That&#8217;s what we&#8217;re going to look at in this article. What is an INSERT INTO SQL request? INSERT INTO SQL is one of the most commonly used commands in the SQL language. And with good reason: [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":176450,"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>INSERT INTO SQL: Insert data with this SQL query<\/title>\n<meta name=\"description\" content=\"The INSERT INTO SQL function can be used for various purpose, under the condition that you respect some crucial...\" \/>\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\/insert-into-sql-insert-data-with-this-sql-query\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"INSERT INTO SQL: Insert data with this SQL query\" \/>\n<meta property=\"og:description\" content=\"To insert data into your SQL table, you can use the INSERT INTOSQL query. But how does it work? That&#039;s what we&#039;re going to look at in this article. What\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query\" \/>\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-16T13:05:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-16T13:06:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/sql-insert-into-datascientest-1024x512-1.png\" \/>\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\/png\" \/>\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\/insert-into-sql-insert-data-with-this-sql-query#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"INSERT INTO SQL: Insert data with this SQL query\",\"datePublished\":\"2024-01-16T13:05:17+00:00\",\"dateModified\":\"2024-01-16T13:06:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query\"},\"wordCount\":755,\"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\/insert-into-sql-insert-data-with-this-sql-query#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query\",\"url\":\"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query\",\"name\":\"INSERT INTO SQL: Insert data with this SQL query\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-16T13:05:17+00:00\",\"dateModified\":\"2024-01-16T13:06:45+00:00\",\"description\":\"The INSERT INTO SQL function can be used for various purpose, under the condition that you respect some crucial...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query\"]}]},{\"@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":"INSERT INTO SQL: Insert data with this SQL query","description":"The INSERT INTO SQL function can be used for various purpose, under the condition that you respect some crucial...","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\/insert-into-sql-insert-data-with-this-sql-query","og_locale":"en_GB","og_type":"article","og_title":"INSERT INTO SQL: Insert data with this SQL query","og_description":"To insert data into your SQL table, you can use the INSERT INTOSQL query. But how does it work? That's what we're going to look at in this article. What","og_url":"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-16T13:05:17+00:00","article_modified_time":"2024-01-16T13:06:45+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/sql-insert-into-datascientest-1024x512-1.png","type":"image\/png"}],"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\/insert-into-sql-insert-data-with-this-sql-query#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"INSERT INTO SQL: Insert data with this SQL query","datePublished":"2024-01-16T13:05:17+00:00","dateModified":"2024-01-16T13:06:45+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query"},"wordCount":755,"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\/insert-into-sql-insert-data-with-this-sql-query#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query","url":"https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query","name":"INSERT INTO SQL: Insert data with this SQL query","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-16T13:05:17+00:00","dateModified":"2024-01-16T13:06:45+00:00","description":"The INSERT INTO SQL function can be used for various purpose, under the condition that you respect some crucial...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/insert-into-sql-insert-data-with-this-sql-query"]}]},{"@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\/176446"}],"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=176446"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176446\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/176450"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=176446"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=176446"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=176446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}