{"id":10383,"date":"2023-02-16T18:58:31","date_gmt":"2023-02-16T13:28:31","guid":{"rendered":"https:\/\/www.skynats.com\/?p=10383"},"modified":"2025-10-22T11:32:08","modified_gmt":"2025-10-22T06:02:08","slug":"indexing-json-data-in-mysql","status":"publish","type":"post","link":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/","title":{"rendered":"Indexing JSON Data in MySQL<\/strong>"},"content":{"rendered":"\n

Putting away JSON in a social data set is something designers have accomplished for a long while. There are different motivations behind why you would need to store JSON in a data set table – client inclinations and design information are two genuine models. The JSON information type was acquainted with MySQL in adaptation 5.7.8. This data type allows storing large JSON documents in a database column while enabling efficient querying using a MySQL<\/mark><\/a> JSON index on the nested values.<\/p>\n\n\n\n

The Potential Issue<\/strong><\/h2>\n\n\n\n

While putting away JSON information in MySQL, we can question the data set in view of values inside that JSON. We can achieve this utilizing an assortment of JSON explicit MySQL capabilities. The potential issue is that inquiry execution can debase over the long run as the quantity of columns increments. At the point when this occurs with different information types, one answer for assist with questioning execution is to add a list to at least one segments. Since MySQL 8.0.13, we have could make practical records. Practical files permit us to make lists in light of articulations, not segment information. We can use this component to make a list in light of JSON values.<\/p>\n\n\n\n

Let’s get Started<\/strong><\/p>\n\n\n\n

Let’s create a straightforward table with a column containing JSON data before creating an index.<\/p>\n\n\n\n

CREATE TABLE `vehicle` (\n\n  `id` INT NOT NULL AUTO_INCREMENT,\n\n  `vehicle_data` JSON NOT NULL,\n\n  PRIMARY KEY (`id`));<\/code><\/pre>\n\n\n\n
After creating the table, Add a few more facts.<\/p>\n\n\n\n
INSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Austine\",\"last_name\":\"Okill\",\"gender\":\"Polygender\",\"manufacturer\":\"GMC\",\"model\":\"Sierra Hybrid\",\"year\":2006,\"vin\":\"5TDBK3EH7BS492643\",\"color\":\"Maroon\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Carrissa\",\"last_name\":\"McGowing\",\"gender\":\"Female\",\"manufacturer\":\"Dodge\",\"model\":\"Avenger\",\"year\":2000,\"vin\":\"WBAPM7C53AE594359\",\"color\":\"Maroon\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Mirabella\",\"last_name\":\"O''Tuohy\",\"gender\":\"Female\",\"manufacturer\":\"Mercury\",\"model\":\"Mountaineer\",\"year\":1997,\"vin\":\"YV4902DZ7E2611356\",\"color\":\"Red\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Marni\",\"last_name\":\"Fratczak\",\"gender\":\"Female\",\"manufacturer\":\"Ford\",\"model\":\"F150\",\"year\":2005,\"vin\":\"WAUVT68EX5A254703\",\"color\":\"Indigo\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Marcelo\",\"last_name\":\"Cellone\",\"gender\":\"Male\",\"manufacturer\":\"Dodge\",\"model\":\"Dakota\",\"year\":2004,\"vin\":\"WBAPH5C55BF851378\",\"color\":\"Turquoise\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Wilden\",\"last_name\":\"Norwell\",\"gender\":\"Bigender\",\"manufacturer\":\"Mercury\",\"model\":\"Sable\",\"year\":1996,\"vin\":\"WAUHFAFL1EA004615\",\"color\":\"Turquoise\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"York\",\"last_name\":\"Hemerijk\",\"gender\":\"Male\",\"manufacturer\":\"Dodge\",\"model\":\"Dakota\",\"year\":2002,\"vin\":\"JTDZN3EU7FJ032100\",\"color\":\"Teal\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Paquito\",\"last_name\":\"Chappelow\",\"gender\":\"Male\",\"manufacturer\":\"Ford\",\"model\":\"Falcon\",\"year\":1967,\"vin\":\"WA1EY94L67D885695\",\"color\":\"Crimson\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Klarrisa\",\"last_name\":\"Ryott\",\"gender\":\"Female\",\"manufacturer\":\"Mitsubishi\",\"model\":\"Tredia\",\"year\":1988,\"vin\":\"1GD12YEG1FF019807\",\"color\":\"Teal\"}');\n\nINSERT INTO vehicle(vehicle_data) values('{\"first_name\":\"Maurice\",\"last_name\":\"Minot\",\"gender\":\"Male\",\"manufacturer\":\"Acura\",\"model\":\"Vigor\",\"year\":1992,\"vin\":\"3C63DRLL0CG858281\",\"color\":\"Indigo\"}');<\/code><\/pre>\n\n\n\n
Here is a more meaningful illustration of the JSON we are putting away.<\/p>\n\n\n\n
{\n\"first_name\":\"Austine\",\n\"last_name\":\"Okill\",\n\"gender\":\"Polygender\",\n\"manufacturer\":\"GMC\",\n\"model\":\"Sierra Hybrid\",\n\"year\":2006,\n\"vin\":\"5TDBK3EH7BS492643\",\n\"color\":\"Maroon\"\n}<\/code><\/pre>\n\n\n\n
Executing a Query<\/h3>\n\n\n\n
Here is a query that we can use to filter our data according to the manufacturer of the vehicles.<\/p>\n\n\n\n
select * from vehicle where vehicle_data->>\"$.manufacturer\" = 'Ford';<\/code><\/pre>\n\n\n\n
Note:<\/em><\/strong> The ->> is shorthand for <\/em>JSON_EXTRACT() within <\/em>JSON_UNQUOTE()<\/p>\n\n\n\n
Although this query doesn’t have any performance issues with our small dataset, it might if more data is added to our table.<\/p>\n\n\n\n
Let’s run the following query to examine the explain plan for this one:<\/p>\n\n\n\n
explain select * from vehicle where vehicle_data->>\"$.manufacturer\" = 'Ford'\\G<\/code><\/pre>\n\n\n\n
Note:<\/em><\/strong> Although this query doesn’t have any performance issues with our small dataset, it might if more data is added to our table.<\/em><\/p>\n\n\n\n
Let’s run the following query to examine the explain plan for this one:<\/em><\/p>\n\n\n\n
*************************** 1. row ***************************\n\n           id: 1\n\n  select_type: SIMPLE\n\n        table: vehicle\n\n   partitions: NULL\n\n         type: ALL\n\npossible_keys: NULL\n\n          key: NULL\n\n      key_len: NULL\n\n          ref: NULL\n\n         rows: 10\n\n     filtered: 100\n\n        Extra: Using where\n\n1 row in set, 1 warning (0.0008 sec)<\/code><\/pre>\n\n\n\n
The values of possible keys and key are the parts of the results that we are most interested in. As we can see, these values are NULL, indicating that there are no indexes available for this query.<\/p>\n\n\n\n
Adding the Index<\/strong><\/h3>\n\n\n\n
We can build an index based on the JSON values to address any potential performance issues with this query. This is how the SQL command would appear:<\/p>\n\n\n\n
ALTER TABLE vehicle\n\n    ADD INDEX manufacturer((\n\n        CAST(vehicle_data->>\"$.manufacturer\" as CHAR(255))\n\n    COLLATE utf8mb4_bin\n\n    ));<\/code><\/pre>\n\n\n\n
Following the execution of this command, the following command can be used to view the definition of the index:<\/p>\n\n\n\n
show indexes from vehicle\\G<\/code><\/pre>\n\n\n\n
This command should return a list of two indexes, including the index for our primary key and the newly created index.<\/p>\n\n\n\n
*************************** 1. row ***************************\n\n        Table: vehicle\n\n   Non_unique: 0\n\n     Key_name: PRIMARY\n\nSeq_in_index: 1\n\n  Column_name: id\n\n    Collation: A\n\n  Cardinality: 9\n\n     Sub_part: NULL\n\n       Packed: NULL\n\n         Null:\n\n   Index_type: BTREE\n\n      Comment:\n\nIndex_comment:\n\n      Visible: YES\n\n   Expression: NULL\n\n*************************** 2. row ***************************\n\n        Table: vehicle\n\n   Non_unique: 1\n\n     Key_name: manufacturer\n\nSeq_in_index: 1\n\n  Column_name: NULL\n\n    Collation: A\n\n  Cardinality: 6\n\n     Sub_part: NULL\n\n       Packed: NULL\n\n         Null: YES\n\n   Index_type: BTREE\n\n      Comment:\n\nIndex_comment:\n\n      Visible: YES\n\n   Expression: (cast(json_unquote(json_extract(`vehicle_data`,_utf8mb4\\'$.manufacturer\\')) as char(255) charset utf8mb4) collate utf8mb4_bin)<\/code><\/pre>\n\n\n\n
At the point when we take a gander at the articulation property of our new list, we can see that the text vehicle_data->>”$.manufacturer” has been replaced with json_unquote(json_extract(vehicle_data,_utf8mb4\\’$.manufacturer\\’)).<\/p>\n\n\n\n
You might be wondering why we chose to create this index using CAST() and COLLATE.<\/p>\n\n\n\n
To start with, the capability JSON_UNQUOTE() returns an information sort of LONGTEXT. The information type LONGTEXT can’t be utilized in a file, so we really want to CAST() the outcomes to an information type that can be recorded. In this model, CHAR(255).<\/p>\n\n\n\n
Then, we use COLLATE on the grounds that the capabilities used to extricate information (utilized in the WHERE articulation in our question) are collated to utf8mb4_bin. Be that as it may, when we cast a string without utilizing COLLATE, it is cast to utf8mb4_0900_ai_ci. At the point when the examination of what is put away in the list doesn’t match the resemblance of the string in our WHERE proviso, the record won’t get utilized.<\/p>\n\n\n\n
Monitoring Our Work<\/h3>\n\n\n\n
Let’s check the effectiveness of our explain plan by rerunning this command after we’ve created the index:<\/p>\n\n\n\n
explain select * from vehicle where vehicle_data->>\"$.manufacturer\" = 'Ford'\\G<\/code><\/pre>\n\n\n\n
The end result ought to resemble this:<\/p>\n\n\n\n
*************************** 1. row ***************************\n\n           id: 1\n\n  select_type: SIMPLE\n\n        table: vehicle\n\n   partitions: NULL\n\n         type: ref\n\npossible_keys: manufacturer\n\n          key: manufacturer\n\n      key_len: 1023\n\n          ref: const\n\n         rows: 2\n\n     filtered: 100\n\n        Extra: NULL\n\n1 row in set, 1 warning (0.0085 sec)<\/code><\/pre>\n\n\n\n
We can see that key and possible key have values now, indicating that this query is using our new index.<\/p>\n\n\n\n
To Conclude<\/h4>\n\n\n\n
Putting away JSON information in a social data set is something engineers have been doing well before a JSON information type existed. With the advent of the MySQL JSON index The JSON information type permits us to store substantial JSON information and run questions in light of the qualities in the JSON object. By utilizing utilitarian files, we can help the presentation of those questions similarly a list on different information types helps support execution.<\/p>\n\n\n\n
Our server support<\/a> team will be available whenever you need them to recover your data if you are having any problems with the MySQL JSON index.<\/p>\n","protected":false},"excerpt":{"rendered":"
Putting away JSON in a social data set is something designers have accomplished for a long while. There are different motivations behind why you would need to store JSON in a data set table – client inclinations and design information are two genuine models. The JSON information type was acquainted with MySQL in adaptation 5.7.8. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[1002,46],"class_list":["post-10383","post","type-post","status-publish","format-standard","hentry","category-blog","tag-mysql-json-index","tag-mysql-server"],"yoast_head":"\nMySQL JSON Index: Enhance Query Performance<\/title>\n<meta name=\"description\" content=\"Boost query performance with MySQL JSON index by indexing JSON data for faster, more efficient database operations.\" \/>\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.skynats.com\/blog\/indexing-json-data-in-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Indexing JSON Data in MySQL\" \/>\n<meta property=\"og:description\" content=\"Boost query performance with MySQL JSON index by indexing JSON data for faster, more efficient database operations.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Server Management Services | Cloud Management | Skynats\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/skynats\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-16T13:28:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-22T06:02:08+00:00\" \/>\n<meta name=\"author\" content=\"Amal K\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:site\" content=\"@skynatstech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Amal K\" \/>\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:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/\"},\"author\":{\"name\":\"Amal K\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/eb9a945e086d898e0851970119204ba2\"},\"headline\":\"Indexing JSON Data in MySQL\",\"datePublished\":\"2023-02-16T13:28:31+00:00\",\"dateModified\":\"2025-10-22T06:02:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/\"},\"wordCount\":792,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"keywords\":[\"mysql json index\",\"mysql server\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/\",\"name\":\"MySQL JSON Index: Enhance Query Performance\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\"},\"datePublished\":\"2023-02-16T13:28:31+00:00\",\"dateModified\":\"2025-10-22T06:02:08+00:00\",\"description\":\"Boost query performance with MySQL JSON index by indexing JSON data for faster, more efficient database operations.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/indexing-json-data-in-mysql\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Indexing JSON Data in MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"name\":\"Server Management Services | Cloud Management | Skynats\",\"description\":\"Server Management and Cloud Management\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#organization\",\"name\":\"Skynats Technologies\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"contentUrl\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Sknats-Logo-New-whole.png\",\"width\":989,\"height\":367,\"caption\":\"Skynats Technologies\"},\"image\":{\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/skynats\",\"https:\\\/\\\/x.com\\\/skynatstech\",\"https:\\\/\\\/www.instagram.com\\\/skynatstech\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/skynats-technologies\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCvTAjrFJ4_E2MJKwlDHomlg\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.skynats.com\\\/blog\\\/#\\\/schema\\\/person\\\/eb9a945e086d898e0851970119204ba2\",\"name\":\"Amal K\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/13013cfcd9ea84e6abbb1ee0bb4d0519034d183895c25cf7845bf4195ce75556?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/13013cfcd9ea84e6abbb1ee0bb4d0519034d183895c25cf7845bf4195ce75556?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/13013cfcd9ea84e6abbb1ee0bb4d0519034d183895c25cf7845bf4195ce75556?s=96&d=mm&r=g\",\"caption\":\"Amal K\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL JSON Index: Enhance Query Performance","description":"Boost query performance with MySQL JSON index by indexing JSON data for faster, more efficient database operations.","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.skynats.com\/blog\/indexing-json-data-in-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Indexing JSON Data in MySQL","og_description":"Boost query performance with MySQL JSON index by indexing JSON data for faster, more efficient database operations.","og_url":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/","og_site_name":"Server Management Services | Cloud Management | Skynats","article_publisher":"https:\/\/www.facebook.com\/skynats","article_published_time":"2023-02-16T13:28:31+00:00","article_modified_time":"2025-10-22T06:02:08+00:00","author":"Amal K","twitter_card":"summary_large_image","twitter_creator":"@skynatstech","twitter_site":"@skynatstech","twitter_misc":{"Written by":"Amal K","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/#article","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/"},"author":{"name":"Amal K","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/eb9a945e086d898e0851970119204ba2"},"headline":"Indexing JSON Data in MySQL","datePublished":"2023-02-16T13:28:31+00:00","dateModified":"2025-10-22T06:02:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/"},"wordCount":792,"commentCount":0,"publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"keywords":["mysql json index","mysql server"],"articleSection":["Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/","url":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/","name":"MySQL JSON Index: Enhance Query Performance","isPartOf":{"@id":"https:\/\/www.skynats.com\/blog\/#website"},"datePublished":"2023-02-16T13:28:31+00:00","dateModified":"2025-10-22T06:02:08+00:00","description":"Boost query performance with MySQL JSON index by indexing JSON data for faster, more efficient database operations.","breadcrumb":{"@id":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.skynats.com\/blog\/indexing-json-data-in-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skynats.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Indexing JSON Data in MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.skynats.com\/blog\/#website","url":"https:\/\/www.skynats.com\/blog\/","name":"Server Management Services | Cloud Management | Skynats","description":"Server Management and Cloud Management","publisher":{"@id":"https:\/\/www.skynats.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skynats.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skynats.com\/blog\/#organization","name":"Skynats Technologies","url":"https:\/\/www.skynats.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","contentUrl":"https:\/\/www.skynats.com\/blog\/wp-content\/uploads\/2021\/08\/Sknats-Logo-New-whole.png","width":989,"height":367,"caption":"Skynats Technologies"},"image":{"@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/skynats","https:\/\/x.com\/skynatstech","https:\/\/www.instagram.com\/skynatstech\/","https:\/\/www.linkedin.com\/company\/skynats-technologies","https:\/\/www.youtube.com\/channel\/UCvTAjrFJ4_E2MJKwlDHomlg"]},{"@type":"Person","@id":"https:\/\/www.skynats.com\/blog\/#\/schema\/person\/eb9a945e086d898e0851970119204ba2","name":"Amal K","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/13013cfcd9ea84e6abbb1ee0bb4d0519034d183895c25cf7845bf4195ce75556?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/13013cfcd9ea84e6abbb1ee0bb4d0519034d183895c25cf7845bf4195ce75556?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/13013cfcd9ea84e6abbb1ee0bb4d0519034d183895c25cf7845bf4195ce75556?s=96&d=mm&r=g","caption":"Amal K"}}]}},"_links":{"self":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/10383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/comments?post=10383"}],"version-history":[{"count":2,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/10383\/revisions"}],"predecessor-version":[{"id":16153,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/posts\/10383\/revisions\/16153"}],"wp:attachment":[{"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/media?parent=10383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/categories?post=10383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skynats.com\/blog\/wp-json\/wp\/v2\/tags?post=10383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}