Working with JSON in MySQL

Click for: original source

Noman Ur Rehman article gives you insights how to use and query JSON data in your MYSQL databases.

What if you could structure some parts of your database and leave others to be flexible? MySQL version 5.7.8 introduces a JSON data type that allows you to accomplish such hybrid approach.

You are going to learn:

  • How to design your database tables using JSON fields
  • The various JSON based functions available in MYSQL to create, read, update, and delete rows
  • How to work with JSON fields using the Eloquent ORM in Laravel

For further reading about JSON in MySQL - consult documentation.

[Read More]

Tags database