{"id":20276,"date":"2020-07-26T22:05:44","date_gmt":"2020-07-27T05:05:44","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=20276"},"modified":"2023-12-01T03:56:11","modified_gmt":"2023-12-01T11:56:11","slug":"sql-insert","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-insert\/","title":{"rendered":"How to Use the SQL INSERT Statement"},"content":{"rendered":"\n<p>Have you ever wondered how data is added to a database? Behind every record in a database is an INSERT INTO statement. Without this statement, databases could not store data!<br><br><\/p>\n\n\n\n<p>In this guide, we\u2019re going to talk about what the INSERT INTO command is and how it works. We\u2019ll walk through a few example queries to help you get started using INSERT INTO.<br><\/p>\n\n\n\n<p>Let\u2019s begin!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is SQL INSERT INTO?<\/h2>\n\n\n\n<p>The INSERT INTO statement adds a record into a database.<br><\/p>\n\n\n\n<p>The statement accepts a list of the column names into which you want to insert values in a record and a list of the corresponding values that you want to set:<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>INSERT INTO table (column1, column2\u2026)\nVALUES (value1, value2\u2026);\n<\/pre><\/div>\n\n\n\n<p>The items in the first set of parentheses are the table column names. The items in the second set of parentheses are the values you want to insert into your record in those columns.<br><\/p>\n\n\n\n<p>It\u2019s no surprise this statement is called INSERT INTO: it allows you to insert a record into a database.<br><\/p>\n\n\n\n<p>Let\u2019s start by <a href=\"https:\/\/careerkarma.com\/blog\/sql-create-table\/\">creating a sample table<\/a> called employees:<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>CREATE TABLE employees (\n\tid INTEGER AUTO INCREMENT,\n\tname VARCHAR(75),\n\ttitle VARCHAR(75),\n\thired_date DATE,\n\tsalary INTEGER\n);\n<\/pre><\/div>\n\n\n\n<p>This command creates a table with four columns: name, title, hired_date and salary. Let\u2019s insert a record into this database!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">INSERT INTO in Action<\/h2>\n\n\n\n<p>We\u2019re starting to populate the employees database with a few records. Our database currently contains the following records:<br><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td><strong>Name<\/strong><\/td><td><strong>Title<\/strong><\/td><td><strong>Hired Date<\/strong><\/td><td><strong>Salary<\/strong><\/td><\/tr><tr><td>Thomas Carlton<\/td><td>Sales Associate<\/td><td>09-08-2019<\/td><td>28000<\/td><\/tr><tr><td>Lisa Ingles<\/td><td>Sales Associate<\/td><td>12-09-2019<\/td><td>28000<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>We want to add in a new record to this database with the following values:<br><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>Victoria Carlisle<\/td><td>Sales Director<\/td><td>04-02-2017<\/td><td>36000<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>To add in this record, we can use an INSERT INTO statement. Open up an SQL shell and paste in the following statement:<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>INSERT INTO employees (name, title, hired_date, salary)\nVALUES ('Victoria Carlisle', 'Sales Director', '05-02-2017', 36000);\n<\/pre><\/div>\n\n\n\n<p>The values you specify must correspond to the data types of the columns in a table. The salary column is structured as an integer. We have specified an integer value for salaries. The hired_date column is formatted as a date. We have specified a date value.<br><\/p>\n\n\n\n<p>This command adds in our record to the database. Let\u2019s select all the records in our employees database:<br><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td><strong>ID<\/strong><\/td><td><strong>Name<\/strong><\/td><td><strong>Title<\/strong><\/td><td><strong>Hired Date<\/strong><\/td><td><strong>Salary<\/strong><\/td><\/tr><tr><td>1<\/td><td>Thomas Carlton<\/td><td>Sales Associate<\/td><td>09-08-2019<\/td><td>28000<\/td><\/tr><tr><td>2<\/td><td>Lisa Ingles<\/td><td>Sales Associate<\/td><td>12-09-2019<\/td><td>28000<\/td><\/tr><tr><td>3<\/td><td>Victoria Carlisle<\/td><td>Sales Director<\/td><td>04-02-2017<\/td><td>36000<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>Victoria Carlisle has been added to the database. Notice how we didn\u2019t specify an employee ID for Victoria. That is because we used an AUTO INCREMENT statement when we <a href=\"https:\/\/careerkarma.com\/blog\/sql-create-table\/\">created our table<\/a>. This statement automatically increments the value of ID by one for each new record created in the table.<br><\/p>\n\n\n\n<p>If you are inserting values into every column in a database, you do not need to specify what columns you are adding data into. This is because SQL can assume based on the number of values specified that they will fill the database.<br><\/p>\n\n\n\n<p>Our above command can be shortened to:<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>INSERT INTO employees\nVALUES ('Victoria Carlisle', 'Sales Director', '05-02-2017', 36000);\n<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">INSERT INTO Using Specific Columns<\/h2>\n\n\n\n<p>You can insert data into a database without specifying a value for all columns. Let\u2019s create a record for a new employee whose title is being changed:<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>INSERT INTO employees VALUES (name, hired_date, salary)\nVALUES ('Justin Peters', '04-11-2018', 33000);\n<\/pre><\/div>\n\n\n\n<p>Our database now contains the following values:<br><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td><strong>ID<\/strong><\/td><td><strong>Name<\/strong><\/td><td><strong>Title<\/strong><\/td><td><strong>Hired Date<\/strong><\/td><td><strong>Salary<\/strong><\/td><\/tr><tr><td>1<\/td><td>Thomas Carlton<\/td><td>Sales Associate<\/td><td>09-08-2019<\/td><td>28000<\/td><\/tr><tr><td>2<\/td><td>Lisa Ingles<\/td><td>Sales Associate<\/td><td>12-09-2019<\/td><td>28000<\/td><\/tr><tr><td>3<\/td><td>Victoria Carlisle<\/td><td>Sales Director<\/td><td>04-02-2017<\/td><td>36000<\/td><\/tr><tr><td>4<\/td><td>Justin Peters<\/td><td>null<\/td><td>04-11-2018<\/td><td>33000<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>We did not specify a title for Justin Peters so the value was set to null by default. This only works if a table supports null values. Otherwise, an error will be returned by the SQL shell.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">INSERT INTO SELECT Statement<\/h2>\n\n\n\n<p>You can insert records into a table that are stored elsewhere in a database. This is useful if you need to create a copy of particular records from one table, or if you need to move the contents of one table into another table.<br><\/p>\n\n\n\n<p>The INSERT INTO SELECT statement is a hybrid between the INSERT INTO and <a href=\"https:\/\/careerkarma.com\/blog\/sql-select\">SELECT<\/a> statements:<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>INSERT INTO table2 (column1, column2\u2026)\nSELECT column1, column2\u2026\nFROM table1\nWHERE condition;\n<\/pre><\/div>\n\n\n\n<p>Let\u2019s say that we want to copy all sales associates into a new table. We could do this using the following command:<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>INSERT INTO sales_associates (name, hired_date, salary)\nSELECT name, hired_date, salary\nFROM employees\nWHERE title = 'Sales Associate';\n<\/pre><\/div>\n\n\n\n<p>This will insert a list of all sales associates\u2019 names, hired dates, and salaries into the sales_associate table:<br><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td><strong>ID<\/strong><\/td><td><strong>Name<\/strong><\/td><td><strong>Hired Date<\/strong><\/td><td><strong>Salary<\/strong><\/td><\/tr><tr><td>1<\/td><td>Thomas Carlton<\/td><td>09-08-2019<\/td><td>28000<\/td><\/tr><tr><td>2<\/td><td>Lisa Ingles<\/td><td>12-09-2019<\/td><td>28000<\/td><\/tr><\/tbody><\/table>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>The INSERT INTO statement adds a record into an SQL database. You do not need to specify all the values that a record can hold when you use INSERT INTO. You can leave some values blank and come back to them later, as long as null values are allowed.<br><\/p>\n\n\n\n<p>As a challenge, write queries for the following:<br><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Add an employee called Sally Pringle with the title Sales Associate to the database. She does not have a hired date or salary because she has not yet started.<\/li><li>Add an employee called Lucas Patterson with the title Marketing Manager to the database. He was hired on 22-04-2019 and has a salary of 36000.<\/li><\/ul>\n\n\n\n<p>Now you\u2019re ready to start using the SQL INSERT INTO statement like an SQL server pro!&nbsp;<br><\/p>\n","protected":false},"excerpt":{"rendered":"Have you ever wondered how data is added to a database? Behind every record in a database is an INSERT INTO statement. Without this statement, databases could not store data! In this guide, we\u2019re going to talk about what the INSERT INTO command is and how it works. We\u2019ll walk through a few example queries&hellip;","protected":false},"author":240,"featured_media":19086,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-20276","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql"},"acf":{"post_sub_title":"","sprint_id":"","query_class":"SQL","school_sft":"","parent_sft":"","school_privacy_policy":"","has_review":null,"is_sponser_post":[],"is_guest_post":[]},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v27.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL INSERT: A Beginner\u2019s Guide | Career Karma<\/title>\n<meta name=\"description\" content=\"The SQL INSERT INTO statement adds a record into a database. On Career Karma, learn how to use the INSERT INTO statement.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/careerkarma.com\/blog\/sql-insert\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Use the SQL INSERT Statement\" \/>\n<meta property=\"og:description\" content=\"The SQL INSERT INTO statement adds a record into a database. On Career Karma, learn how to use the INSERT INTO statement.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-insert\/\" \/>\n<meta property=\"og:site_name\" content=\"Career Karma\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/careerkarmaapp\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-27T05:05:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-01T11:56:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"667\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"James Gallagher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@career_karma\" \/>\n<meta name=\"twitter:site\" content=\"@career_karma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"James Gallagher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\":\"Article\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/\"},\"author\":{\"name\":\"James Gallagher\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"headline\":\"How to Use the SQL INSERT Statement\",\"datePublished\":\"2020-07-27T05:05:44+00:00\",\"dateModified\":\"2023-12-01T11:56:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/\"},\"wordCount\":836,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-insert\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/\",\"name\":\"SQL INSERT: A Beginner\u2019s Guide | Career Karma\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg\",\"datePublished\":\"2020-07-27T05:05:44+00:00\",\"dateModified\":\"2023-12-01T11:56:11+00:00\",\"author\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"description\":\"The SQL INSERT INTO statement adds a record into a database. On Career Karma, learn how to use the INSERT INTO statement.\",\"breadcrumb\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-insert\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/#primaryimage\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg\",\"width\":1000,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-insert\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/careerkarma.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\/\/careerkarma.com\/blog\/sql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Use the SQL INSERT Statement\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\",\"url\":\"https:\/\/careerkarma.com\/blog\/\",\"name\":\"Career Karma\",\"description\":\"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/careerkarma.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\",\"name\":\"James Gallagher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg\",\"caption\":\"James Gallagher\"},\"description\":\"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.\",\"url\":\"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL INSERT: A Beginner\u2019s Guide | Career Karma","description":"The SQL INSERT INTO statement adds a record into a database. On Career Karma, learn how to use the INSERT INTO statement.","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:\/\/careerkarma.com\/blog\/sql-insert\/","og_locale":"en_US","og_type":"article","og_title":"How to Use the SQL INSERT Statement","og_description":"The SQL INSERT INTO statement adds a record into a database. On Career Karma, learn how to use the INSERT INTO statement.","og_url":"https:\/\/careerkarma.com\/blog\/sql-insert\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2020-07-27T05:05:44+00:00","article_modified_time":"2023-12-01T11:56:11+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg","type":"image\/jpeg"}],"author":"James Gallagher","twitter_card":"summary_large_image","twitter_creator":"@career_karma","twitter_site":"@career_karma","twitter_misc":{"Written by":"James Gallagher","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/"},"author":{"name":"James Gallagher","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"headline":"How to Use the SQL INSERT Statement","datePublished":"2020-07-27T05:05:44+00:00","dateModified":"2023-12-01T11:56:11+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/"},"wordCount":836,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-insert\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/","url":"https:\/\/careerkarma.com\/blog\/sql-insert\/","name":"SQL INSERT: A Beginner\u2019s Guide | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg","datePublished":"2020-07-27T05:05:44+00:00","dateModified":"2023-12-01T11:56:11+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"description":"The SQL INSERT INTO statement adds a record into a database. On Career Karma, learn how to use the INSERT INTO statement.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-insert\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/07\/maxwell-nelson-Ix64NPGxZoQ-unsplash.jpg","width":1000,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-insert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/careerkarma.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL","item":"https:\/\/careerkarma.com\/blog\/sql\/"},{"@type":"ListItem","position":3,"name":"How to Use the SQL INSERT Statement"}]},{"@type":"WebSite","@id":"https:\/\/careerkarma.com\/blog\/#website","url":"https:\/\/careerkarma.com\/blog\/","name":"Career Karma","description":"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/careerkarma.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94","name":"James Gallagher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/01\/james-gallagher-150x150.jpg","caption":"James Gallagher"},"description":"James Gallagher is a self-taught programmer and the technical content manager at Career Karma. He has experience in range of programming languages and extensive expertise in Python, HTML, CSS, and JavaScript. James has written hundreds of programming tutorials, and he frequently contributes to publications like Codecademy, Treehouse, Repl.it, Afrotech, and others.","url":"https:\/\/careerkarma.com\/blog\/author\/jamesgallagher\/"}]}},"_links":{"self":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/20276","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/users\/240"}],"replies":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/comments?post=20276"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/20276\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/19086"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=20276"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=20276"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=20276"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}