Skip to content

A stored procedure in SQL that takes a JSON object as input which contains n key/value pairs.

Notifications You must be signed in to change notification settings

alistairhewitt/json_to_table

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 

Repository files navigation

json_to_table

A stored procedure in SQL that takes a JSON object as input which contains n key/value pairs.

The procedure uses a Common Table Expression and outputs a result set that contains two columns: key and value. If the input is invalid or not a JSON object, it throws error 333.

This procedure is intended for use with MariaDB 10.4.

About

A stored procedure in SQL that takes a JSON object as input which contains n key/value pairs.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published