Answer the question
In order to leave comments, you need to log in
Why is json not supported in mysql?
Mysql >5.7.8 supports json. It was 5.6, updated to 5.7 to support json. System: cent os 6 (aws ec2).
mysql --version
mysql Ver 14.14 Distrib 5.7.23, for Linux (x86_64) using EditLine wrapper
Package mysql57-5.7.23-2.9.amzn1.x86_64 already installed and latest version
ALTER TABLE mytable ADD COLUMN `data` JSON
#1064 - You have an error in your request. Check the documentation for your version of MySQL for the correct syntax near 'JSON' on line 2
Answer the question
In order to leave comments, you need to log in
I understood the problem. I do not know how this is possible, but on the server there are 2 versions of mysql. The mysql --version command uses the new one, but the application uses the old one.
I thought when installing a new one, it updates and takes data from the old one, but apparently in cent os it's somehow different.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question