MySQL Stored Procedure for CRUD Dynamic Queries

The new MySQL 5.7 version has some great features.
One of them is the ‘JSON data’ type. We can use it for column of table like ‘Virtual Colunm’ with Indexing.

But, ‘JSON data’ is also useful for stored procedure. Because we can compact parameters and the procedure could be more flexible.I made the procedures for table insert/update via JSON parameter.
When I apply them to my project, data-handling codes in the application decreased dramatically.

(These procedures impliment ‘MySQL Procedure Pattern for Nested Transaction‘)

The code below is an old version. The latest source code is in Github.
Go to the Github repository >>

QR Code