{"id":12415,"date":"2020-11-17T14:30:50","date_gmt":"2020-11-17T22:30:50","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=12415"},"modified":"2023-12-01T04:04:07","modified_gmt":"2023-12-01T12:04:07","slug":"sql-add-column","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-add-column\/","title":{"rendered":"SQL Add Column: A How-To Guide"},"content":{"rendered":"\n<p><em>There is no SQL ADD COLUMN statement. To add a column to an SQL table, you must use the ALTER TABLE ADD syntax. ALTER TABLE lets you add, delete, or modify columns in a table.<\/em><\/p>\n\n\n\n<p>After you have created a table in <em>SQL<\/em>, you may realize that you forgot to add in a specific column that you need. For example, say you may have created a database to store a list of suppliers. Maybe you forgot to include a field to store the category of goods the supplier offers.<\/p>\n\n\n\n<p>In these situations, you can use the <em>SQL ALTER TABLE<\/em> statement to amend an existing table. This statement allows you to add a column, change a column, or delete a column.<\/p>\n\n\n\n<p>In this tutorial, we will break down the basics of the <em>SQL ALTER TABLE <\/em>statement. We&#8217;ll walk through an example to show how you can use the add column SQL syntax to create a new column in a table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Creating a Table<\/h2>\n\n\n\n<p>Below is an <em>SQL<\/em> command that will create an employee database that stores three columns. This database stores name of an employee, their title, and the branch for which they work.<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>CREATE TABLE employees (\n\tname VARCHAR(50) NOT NULL,\n\ttitle VARCHAR(75) NOT NULL,\n\tbranch VARCHAR(25) NOT NULL\n);<\/pre><\/div>\n\n\n\n<p>But what if we\u2019ve forgotten to add a column? Say we need to add a column that states whether an employee is on probation. That\u2019s where the <em>ALTER TABLE<\/em> statement comes in.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Add Column<\/h2>\n\n\n\n<p>To perform an SQL add column operation, use the ALTER TABLE ADD command. This command alters a table and adds in a column with the specified data type. Using this command, you can add a column to a table after you have created the table.<\/p>\n\n\n\n<p>As we discussed above, we forgot to include a column that stores whether an employee is on probation. We can use the <em>ALTER TABLE<\/em> statement to alter our existing table and add in this new column.<\/p>\n\n\n\n<p>The basic syntax for adding a new column is as follows:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>ALTER TABLE table_name ADD column_name data_type constraints;<\/pre><\/div>\n\n\n\n<p>The <em>SQL ALTER TABLE add column<\/em> statement we have written above takes four arguments. First, we specify the name of our table. Then, we state name of the column we want to create.<\/p>\n\n\n\n<p>Next, we specify data type we want that column to have. The last argument contains any constraints we want our new column to have. <\/p>\n\n\n\n<p>Our new column is added to the database schema. We can set the value of the new column in any existing records using an <a href=\"https:\/\/careerkarma.com\/blog\/sql-update\/\">SQL UPDATE statement<\/a>. If we create a new record, we can use the <a href=\"https:\/\/careerkarma.com\/blog\/sql-insert\/\">SQL INSERT command<\/a>. We will be asked to specify a value for the new column in any new records we add to the table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Add Column to Table SQL Example<\/h2>\n\n\n\n<p>Let&#8217;s perform an SQL add column to table action. We&#8217;ll add a fourth column to an existing table, our &#8220;employees&#8221; table:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>ALTER TABLE employees ADD probation BOOLEAN;<\/pre><\/div>\n\n\n\n<p>Now our table appears as follows:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>Column Name<\/td><td>Data Type<\/td><td>Constraints<\/td><\/tr><tr><td>Name<\/td><td>VARCHAR(50)<\/td><td>NOT NULL<\/td><\/tr><tr><td>Title<\/td><td>VARCHAR(75)<\/td><td>NOT NULL<\/td><\/tr><tr><td>Branch<\/td><td>VARCHAR(25)<\/td><td>NOT NULL<\/td><\/tr><tr><td>Probation<\/td><td>BOOLEAN<\/td><td><br><\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>The fourth column is called probation. It has been added to our table with the boolean data type.<\/p>\n\n\n\n<p>If you want to add a column with an <a href=\"https:\/\/careerkarma.com\/blog\/sql-constraints\/\">SQL <em>NOT NULL<\/em> constraint<\/a> to an existing table, you must specify a default value. You can do this using the <em>DEFAULT<\/em> constraint. This is because <em>NOT NULL<\/em> protects a database against null values, and that policy applies to existing records.&nbsp;<\/p>\n\n\n\n<p>Here\u2019s an example of this in action:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>ALTER TABLE employees ADD probation BOOLEAN NOT NULL DEFAULT false;<\/pre><\/div>\n\n\n\n<p>Now our probation column has a <em>NOT NULL<\/em> value, and every employee\u2019s probation status has been set to <em>false<\/em> in the database. Here\u2019s a query that we can use to find employee names and their probation statuses:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT name, probation FROM employees;<\/pre><\/div>\n\n\n\n<p>Our query returns the following:<\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td>name<\/td><td>probation<\/td><\/tr><tr><td>Luke<\/td><td>f<\/td><\/tr><tr><td>Mike<\/td><td>f<\/td><\/tr><tr><td>Hannah<\/td><td>f<\/td><\/tr><tr><td>Geoff<\/td><td>f<\/td><\/tr><tr><td>Alexis<\/td><td>f<\/td><\/tr><tr><td>Emma<\/td><td>f<\/td><\/tr><tr><td>Jonah<\/td><td>f<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p><em>SQL ALTER TABLE<\/em> has a wide range of other functions. You can use the statement to drop a column or rename a table column in an existing table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Add Multiple Columns to a Table<\/h2>\n\n\n\n<p>You can add multiple columns to an SQL table using the ALTER TABLE syntax. To do so, specify multiple columns to add after the ADD keyword. Separate each column you want to add using a comma.<\/p>\n\n\n\n<p>Suppose that we want to add two columns called &#8220;salary&#8221; and &#8220;bio&#8221; to our existing &#8220;employees&#8221; table. We could do so using this command:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>ALTER TABLE employees\nADD salary FLOAT,\nADD bio VARCHAR(250);<\/pre><\/div>\n\n\n\n<p>We&#8217;ve added two columns to our table. The &#8220;salary&#8221; column stores a floating-point number (a number that can store a decimal). Our &#8220;bio&#8221; column is a text field that can store up to 250 characters.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>The <em>ALTER TABLE<\/em> statement lets you add a column to a table on an SQL server. You must use the ALTER TABLE ADD keyword to add a column to a table. There is no ADD COLUMN command that adds a column to a statement.<\/p>\n\n\n\n<p>To learn more about coding in SQL, read our <a href=\"https:\/\/careerkarma.com\/blog\/learn-sql\/\">How to Learn SQL guide<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"There is no SQL ADD COLUMN statement. To add a column to an SQL table, you must use the ALTER TABLE ADD syntax. ALTER TABLE lets you add, delete, or modify columns in a table. After you have created a table in SQL, you may realize that you forgot to add in a specific column&hellip;","protected":false},"author":240,"featured_media":12416,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-12415","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 Add Column: A How-To Guide | Career Karma<\/title>\n<meta name=\"description\" content=\"Adding a column to an existing table is a common operation in SQL. Learn more about how to add a new column in SQL on Career Karma.\" \/>\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-add-column\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Add Column: A How-To Guide\" \/>\n<meta property=\"og:description\" content=\"Adding a column to an existing table is a common operation in SQL. Learn more about how to add a new column in SQL on Career Karma.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-add-column\/\" \/>\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-11-17T22:30:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-01T12:04:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/\"},\"author\":{\"name\":\"James Gallagher\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"headline\":\"SQL Add Column: A How-To Guide\",\"datePublished\":\"2020-11-17T22:30:50+00:00\",\"dateModified\":\"2023-12-01T12:04:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/\"},\"wordCount\":826,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-add-column\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/\",\"name\":\"SQL Add Column: A How-To Guide | Career Karma\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.jpg\",\"datePublished\":\"2020-11-17T22:30:50+00:00\",\"dateModified\":\"2023-12-01T12:04:07+00:00\",\"author\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94\"},\"description\":\"Adding a column to an existing table is a common operation in SQL. Learn more about how to add a new column in SQL on Career Karma.\",\"breadcrumb\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-add-column\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/#primaryimage\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.jpg\",\"width\":1000,\"height\":667},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-add-column\/#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\":\"SQL Add Column: A How-To Guide\"}]},{\"@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 Add Column: A How-To Guide | Career Karma","description":"Adding a column to an existing table is a common operation in SQL. Learn more about how to add a new column in SQL on Career Karma.","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-add-column\/","og_locale":"en_US","og_type":"article","og_title":"SQL Add Column: A How-To Guide","og_description":"Adding a column to an existing table is a common operation in SQL. Learn more about how to add a new column in SQL on Career Karma.","og_url":"https:\/\/careerkarma.com\/blog\/sql-add-column\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2020-11-17T22:30:50+00:00","article_modified_time":"2023-12-01T12:04:07+00:00","og_image":[{"width":1000,"height":667,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/"},"author":{"name":"James Gallagher","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"headline":"SQL Add Column: A How-To Guide","datePublished":"2020-11-17T22:30:50+00:00","dateModified":"2023-12-01T12:04:07+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/"},"wordCount":826,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-add-column\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/","url":"https:\/\/careerkarma.com\/blog\/sql-add-column\/","name":"SQL Add Column: A How-To Guide | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.jpg","datePublished":"2020-11-17T22:30:50+00:00","dateModified":"2023-12-01T12:04:07+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/e79364792443fbff794a144c67ec8e94"},"description":"Adding a column to an existing table is a common operation in SQL. Learn more about how to add a new column in SQL on Career Karma.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-add-column\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/02\/SQL-ADD-COLUMN.jpg","width":1000,"height":667},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-add-column\/#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":"SQL Add Column: A How-To Guide"}]},{"@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\/12415","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=12415"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/12415\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/12416"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=12415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=12415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=12415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}