php with mysql

MySQL 8 is going to have new batch of JSON functions and last time JSON_PRETTY() was covered in some details. The recent release of 8.0.1 provides an opportunity to try these new functions and a few that might have been missed with 8.0.0. Unquoting The -> shortcut for JSON_EXTRACT() was introduced with MySQL 5.7. And now there is the unquoting extraction operator or ->> to simplify things again! Think of it as JSON_UNQUOTE wrapped around JSON EXTRACT . The following there queries produce the same output. mysql> SELECT JSON_UNQUOTE(JSON_EXTRACT(doc,"$.GNP")) FROM countryinfo WHERE _id = "USA"; +-----------------------------------------+ | JSON_UNQUOTE(JSON_EXTRACT(doc,"$.GNP")) | +-----------------------------------------+ | 8510700 | +-----------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT JSON_UNQUOTE(doc->"$.GNP") FROM countryinfo WHERE _id = "USA"...

JSON is a great way to share data and is highly praised in being human readable. Well, compared to XML and some other standards it is easier to read. But sometimes the data looks mushed or wilted. mysql> SELECT doc FROM countryinfo WHERE _id='USA'; ... {"GNP": 8510700, "_id": "USA", "Name": "United States", "IndepYear": 1776, "geography": {"Region": "North America", "Continent": "North America", "SurfaceArea": 9363520}, "government": {"HeadOfState": "George W. Bush", "GovernmentForm": "Federal Republic"}, "demographics": {"Population": 278357000, "LifeExpectancy": 77.0999984741211}} 1 row in set (0.00 sec) And 'easy' is relative, right? Well, what if you had a way to make it easier to read, er, pretty? MySQL 8.0.1 has a few new JSON functions but one of them is designe...