~/talk

JSON support in MySQL

on YouTube 30m
Talkat FOSSASIA Summit 2017 · 2017-03-17..03-19· [databases]

speaker

name:Evgeny Potemkin
website:http://mysqlserverteam.com/author/evgen

resources

video:https://youtu.be/2G8B4tmlrBk
slides:none on file

summary

Covers MySQL’s JSON capabilities: how JSON is stored, the functions provided to manipulate JSON values, indexing options for JSON data, and strategies for managing schemaless JSON alongside traditional relational data.

AI-written summary · about

chapters (12)

  1. 0:00Intro
  2. 0:17Safe Harbor Statement
  3. 0:53JSON Overview
  4. 2:50Aggregate functions
  5. 3:42E-A-V example: schema
  6. 4:00E-A-V example: data
  7. 4:24E-A-V example: attributes-values query
  8. 6:45E-A-V example: products query result
  9. 8:27JSON_TABLE function
  10. 14:58JSON_TABLE Syntax: cont.
  11. 21:58JSON_TABLE: example #2, source data
  12. 23:49JSON_TABLE: example #2, result

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.