49225

How to create index on json column in MySQL?

<h3>Question</h3>

How to create index on sub-documents in Json data type in MySQL server?

I know we have to create a generated column from the base table and then need to index that column Virtually or stored.

But I want syntax for creating a generated column for sub-document.


<h3>Answer1:</h3>

JSON columns, like columns of other binary types, are not indexed directly; instead, you can create an index on a generated column that extracts a scalar value from the JSON column. See Section “Secondary Indexes and Generated Virtual Columns”, for a detailed example.

来源:https://stackoverflow.com/questions/38389075/how-to-create-index-on-json-column-in-mysql

Recommend

  • BoundingBox around a geo coordinate
  • MATLAB urlread Won't Work for Specific Webpage
  • Sending email with VBA under the same Outlook conversation
  • Programmatically Get the Incoming/Outgoing COM Bluetooth Port.How can do it in Windows Mobile 6 App
  • Normalization does not preserve code point
  • How to access Safari history from iPhone App using Private Frameworks
  • Issue with java String and String Builder
  • Adding a delete button in PHP on each row of a MySQL table
  • How to add a CAGradientLayer to a UIView when using programmatic constraints
  • JQuery and PHP validation problem?
  • How to create 2 svg's on one page?
  • AppEngine Paypal integration giving SSLCertificateError on localhost, using Python
  • Highlight special word in a TextBox
  • Windows 8 Flexboxes - Nesting Flexboxes with overflow enabled
  • device tree overlay phandle
  • Arc gradients in Flutter?
  • Gradle refresh removes source folders in build path
  • Planned Contrasts on glmmTMB
  • plot dirac function in matlab
  • Laravel 5 - Cache remember doesn't work
  • SELECT on JSONField with Django
  • Jekyll - How do I create pages in the root directory?
  • iOS App crash issue `[UIWindow warpPoint:]`
  • Java 11 and E(fx)clipse JavaFX plugin on Eclipse 4.9: An error has occurred - see the log file
  • Python ctypes: Prototype with LPCSTR [out] parameter
  • android : speech recognition what are the technologies available
  • How to move to lines with the same indentation in Visual Studio Code
  • $this->a->b->c->d calling methods from a superclass in php
  • How do I set the logging properties in a spring java configuration?
  • Google TV VideoView playing YouTube rtsp videos
  • How can I filter an array of dictionaries in 'updateSearchResultsForSearchController' to s
  • Unable to run testNG tests from maven
  • LINQ to populate treeview based upon grouping
  • Reload Page with Javascript after Database changes
  • How to check if a database and tables exist in sql server in a vb .net project?
  • Annotate objects in a queryset with next and previous object ids
  • Rotating Towards Path in OpenGL
  • Is there a better way for handling SpatialPolygons that cross the antimeridian (date line)?
  • How to change user identity when git pushing via ssh?
  • Grails - How to implement a foreign key relationship not using an id column?