Menu
JSON datatype is supported in mysql from 5.7.8 onwards.
Google cloud sql faq - says second generation instances are on 5.6 and 5.7. Minor version updates are deployed as they are released, with no further action required on your part.
Can anybody tell me what exact version does google cloud sql is using right now or whether it supports JSON datatype.
740
SQL Server and Azure SQL Database have native JSON functions that enable you to parse JSON documents using standard SQL language. You can store JSON documents in SQL Server or SQL Database and query JSON data as in a NoSQL database.
The best database for JSON A JSON database like MongoDB stores the data in a JSON-like format (binary JSON), which is the binary encoded version of JSON, and is optimized for performance and space. This makes the MongoDB database the best natural fit for storing JSON data.
JSON Support in PostgreSQL, MySQL, MongoDB, and SQL Server.
The current version is 5.7.11 and you are able to use JSON types.
You can check the version yourself using SELECT @@version;:
MySQL [(none)]> select @@version;
+-------------------+
| @@version |
+-------------------+
| 5.7.11-google-log |
+-------------------+
1 row in set (0.12 sec)
JSON field types were added in MySQL version 5.7.8.
The current version in Google Cloud SQL is MySQL v5.7.11.
So yes, JSON colum types are supported.
45
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
