CODEWITHSUNDEEP
google-cloud-platformgoogle-cloud-sql
npr
npr

Reputation: 4765

Does Google Cloud SQL support JSON datatype?

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.

Upvotes: 6

Views: 3574

Answers (2)

Dzhuneyt
Dzhuneyt

Reputation: 8701

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.

Upvotes: 3

Vadim
Vadim

Reputation: 5126

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)

Upvotes: 7

Related Questions