{"id":12022,"date":"2023-11-02T06:56:43","date_gmt":"2023-11-02T13:56:43","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=12022"},"modified":"2023-11-02T06:57:07","modified_gmt":"2023-11-02T13:57:07","slug":"mysql-json_insert","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/","title":{"rendered":"MySQL JSON_INSERT() Function"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use the MySQL <code>JSON_INSERT()<\/code> function to insert new elements to a JSON document.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to MySQL JSON_INSERT() function<\/h2>\n\n\n\n<p>The <code>JSON_INSERT()<\/code> function allows you to add one or more elements to a JSON document.<\/p>\n\n\n\n<p>Here&#8217;s the syntax of the <code>JSON_INSERT()<\/code> function:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">JSON_INSERT(json_doc, path, value&#91;, path, value] ...)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this syntax:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>json_doc<\/code>: This is the JSON document you want to insert data into.<\/li>\n\n\n\n<li><code>path<\/code>: The <a href=\"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json-path\/\">JSON path<\/a> that specifies the position in the <code>json_doc<\/code> where you want to insert the new value.<\/li>\n\n\n\n<li><code>value<\/code>: The value you want to insert.<\/li>\n<\/ul>\n\n\n\n<p>Note that you can insert multiple values at the positions specified by paths in a single function call.<\/p>\n\n\n\n<p>The <code>JSON_INSERT()<\/code> function processes the path\/value pair one by one, starting from the left. It evaluates the first pair and uses the updated JSON document for evaluating the next pair till to the last pair.<\/p>\n\n\n\n<p>If the path exists in the JSON document, the function ignores and doesn&#8217;t replace the current value in the JSON document. <\/p>\n\n\n\n<p>If the path doesn&#8217;t exist in the JSON document, the <code>JSON_INSERT()<\/code> function will: <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add the key\/value to an object if the member is not present in an existing object.<\/li>\n\n\n\n<li>Extend an array with a new value if the path specifies an element after the last element of an existing array. If the existing value is not an array, the function wraps it as an array and then extends it with a new value.<\/li>\n<\/ul>\n\n\n\n<p>Otherwise, the function will also ignore the nonexisting path in the document.<\/p>\n\n\n\n<p>The <code>JSON_INSERT()<\/code> function returns the new document with the values inserted into the <code>json_doc<\/code> at the specified paths.<\/p>\n\n\n\n<p>The function returns <code>NULL<\/code> if any argument is <code>NULL<\/code>. Also, it issues an error if the <code>json_doc<\/code> is not a valid JSON document or if the path is not a valid path expression, or if one of the paths contains an asterisk (*) or double asterisk (**) wildcard.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL JSON_INSERT() function examples<\/h2>\n\n\n\n<p>Let&#8217;s take some examples of using the <code>JSON_INSERT()<\/code> function.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1) Inserting a new value into an existing object<\/h3>\n\n\n\n<p>The following example uses the <code>JSON_INSERT()<\/code> function to insert a new key\/value pair into an object in a JSON document:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n  JSON_INSERT(\n    <span class=\"hljs-string\">'{\"name\": \"John\", \"age\": 30}'<\/span>, <span class=\"hljs-string\">'$.job'<\/span>, \n    <span class=\"hljs-string\">'MySQL Expert'<\/span>\n  ) <span class=\"hljs-keyword\">AS<\/span> updated_json;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">+<span class=\"hljs-comment\">----------------------------------------------------+<\/span>\n| updated_json                                       |\n+<span class=\"hljs-comment\">----------------------------------------------------+<\/span>\n| {\"age\": 30, \"job\": \"MySQL Expert\", \"name\": \"John\"} |\n+<span class=\"hljs-comment\">----------------------------------------------------+<\/span>\n1 row in <span class=\"hljs-keyword\">set<\/span> (<span class=\"hljs-number\">0.02<\/span> sec)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this example, we inserted the key &#8220;job&#8221; with the value &#8220;MySQL Expert&#8221; into an existing object of the JSON document.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2) Inserting into nested objects<\/h3>\n\n\n\n<p>The following example uses the <code>JSON_INSERT()<\/code> function to insert values into nested objects within a JSON document:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">\n<span class=\"hljs-keyword\">SELECT<\/span> \n  JSON_INSERT(\n    <span class=\"hljs-string\">'{\"person\": {\"name\": \"Alice\", \"address\": {\"city\": \"Los Angeles\"}}}'<\/span>, \n    <span class=\"hljs-string\">'$.person.address.zip'<\/span>, <span class=\"hljs-string\">'90001'<\/span>\n  ) <span class=\"hljs-keyword\">AS<\/span> updated_json;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this example, we have an object with the key person and a nested object with the key address. <\/p>\n\n\n\n<p>We use the <code>JSON_INSERT()<\/code> function to insert the key zip with the value 90001 into the address object.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3) Inserting into arrays<\/h3>\n\n\n\n<p>The following example uses the <code>JSON_INSERT()<\/code> function to add a value to a JSON array:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n  JSON_INSERT(\n    <span class=\"hljs-string\">'{\"skills\":&#91;\"MySQL\",\"PHP\",\"JavaScript\"]}'<\/span>, \n    <span class=\"hljs-string\">'$.skills&#91;3]'<\/span>, \n     <span class=\"hljs-string\">'React'<\/span>\n  ) <span class=\"hljs-keyword\">AS<\/span> updated_json;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">+<span class=\"hljs-comment\">-----------------------------------------------------+<\/span>\n| updated_json                                        |\n+<span class=\"hljs-comment\">-----------------------------------------------------+<\/span>\n| {\"skills\": &#91;\"MySQL\", \"PHP\", \"JavaScript\", \"React\"]} |\n+<span class=\"hljs-comment\">-----------------------------------------------------+<\/span>\n1 row in <span class=\"hljs-keyword\">set<\/span> (<span class=\"hljs-number\">0.00<\/span> sec)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The reason we can add a value because the path $.skills[3] does not exist in the document. <\/p>\n\n\n\n<p>If you specify a path that exists in the document, the <code>JSON_INSERT()<\/code> function ignores it like this:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n  JSON_INSERT(\n    <span class=\"hljs-string\">'{\"skills\":&#91;\"MySQL\",\"PHP\",\"JavaScript\"]}'<\/span>, \n    <span class=\"hljs-string\">'$.skills&#91;1]'<\/span>, \n     <span class=\"hljs-string\">'React'<\/span>\n  ) <span class=\"hljs-keyword\">AS<\/span> <span class=\"hljs-keyword\">result<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">+<span class=\"hljs-comment\">--------------------------------------------+<\/span>\n| result                                     |\n+<span class=\"hljs-comment\">--------------------------------------------+<\/span>\n| {\"skills\": &#91;\"MySQL\", \"PHP\", \"JavaScript\"]} |\n+<span class=\"hljs-comment\">--------------------------------------------+<\/span>\n1 row in <span class=\"hljs-keyword\">set<\/span> (<span class=\"hljs-number\">0.00<\/span> sec)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The JSON document doesn&#8217;t change.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">4) Inserting multiple values<\/h3>\n\n\n\n<p>The following example uses the <code>JSON_INSERT()<\/code> function to insert two new values into an existing JSON object:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n  JSON_INSERT(\n    <span class=\"hljs-string\">'{\"name\": \"John\", \"age\": 25}'<\/span>, <span class=\"hljs-string\">'$.city'<\/span>, \n    <span class=\"hljs-string\">'San Jose'<\/span>, <span class=\"hljs-string\">'$.country'<\/span>, <span class=\"hljs-string\">'USA'<\/span>\n  ) <span class=\"hljs-keyword\">result<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-10\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">+<span class=\"hljs-comment\">-------------------------------------------------------------------+<\/span>\n| result                                                            |\n+<span class=\"hljs-comment\">-------------------------------------------------------------------+<\/span>\n| {\"age\": 25, \"city\": \"San Jose\", \"name\": \"John\", \"country\": \"USA\"} |\n+<span class=\"hljs-comment\">-------------------------------------------------------------------+<\/span>\n1 row in <span class=\"hljs-keyword\">set<\/span> (<span class=\"hljs-number\">0.00<\/span> sec)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-10\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the <code>JSON_INSERT()<\/code> function to insert one or more values into a JSON document specified at specified paths.<\/li>\n<\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful? <\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"12022\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/\"\n\t\t\t\tdata-post-title=\"MySQL JSON_INSERT() Function\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"12022\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/\"\n\t\t\t\tdata-post-title=\"MySQL JSON_INSERT() Function\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summary: in this tutorial, you will learn how to use the MySQL JSON_INSERT() function to insert new elements to a JSON document. Introduction to MySQL JSON_INSERT() function The JSON_INSERT() function allows you to add one or more elements to a JSON document. Here&#8217;s the syntax of the JSON_INSERT() function: In this syntax: Note that you [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":11973,"menu_order":9,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-12022","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL JSON_INSERT() Function<\/title>\n<meta name=\"description\" content=\"In this tutorial, you will learn how to use the MySQL JSON_INSERT() function to add new elements or values to a JSON document.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL JSON_INSERT() Function\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn how to use the MySQL JSON_INSERT() function to add new elements or values to a JSON document.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/\" \/>\n<meta property=\"og:site_name\" content=\"MySQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T13:57:07+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-json\\\/mysql-json_insert\\\/\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-json\\\/mysql-json_insert\\\/\",\"name\":\"MySQL JSON_INSERT() Function\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\"},\"datePublished\":\"2023-11-02T13:56:43+00:00\",\"dateModified\":\"2023-11-02T13:57:07+00:00\",\"description\":\"In this tutorial, you will learn how to use the MySQL JSON_INSERT() function to add new elements or values to a JSON document.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-json\\\/mysql-json_insert\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-json\\\/mysql-json_insert\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-json\\\/mysql-json_insert\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL JSON\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-json\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL JSON_INSERT() Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\",\"name\":\"MySQL Tutorial\",\"description\":\"A comprehensive MySQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mysqltutorial.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL JSON_INSERT() Function","description":"In this tutorial, you will learn how to use the MySQL JSON_INSERT() function to add new elements or values to a JSON document.","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:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/","og_locale":"en_US","og_type":"article","og_title":"MySQL JSON_INSERT() Function","og_description":"In this tutorial, you will learn how to use the MySQL JSON_INSERT() function to add new elements or values to a JSON document.","og_url":"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/","og_site_name":"MySQL Tutorial","article_modified_time":"2023-11-02T13:57:07+00:00","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/","url":"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/","name":"MySQL JSON_INSERT() Function","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"datePublished":"2023-11-02T13:56:43+00:00","dateModified":"2023-11-02T13:57:07+00:00","description":"In this tutorial, you will learn how to use the MySQL JSON_INSERT() function to add new elements or values to a JSON document.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-json\/mysql-json_insert\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL JSON","item":"https:\/\/www.mysqltutorial.org\/mysql-json\/"},{"@type":"ListItem","position":3,"name":"MySQL JSON_INSERT() Function"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/12022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/comments?post=12022"}],"version-history":[{"count":5,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/12022\/revisions"}],"predecessor-version":[{"id":12027,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/12022\/revisions\/12027"}],"up":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/11973"}],"wp:attachment":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media?parent=12022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}