Top "Mysql-5.7" questions

Alter an existing mysql column to a JSON data type

I am trying to change a MySQL column from varchar(9000) NULL to the new JSON data type in MySQL 5.7. The …

mysql json mysql-5.7

MySQL select where JSON field property has value

How to write a basic MySQL query that has a WHERE on a property within a JSON data-type field? I …

mysql json mysql-5.7

Error setting up MySQL: Table 'mysql.plugin' doesn't exist

I have a MySQL 5.7 instance running without problems on Ubuntu 16, but when i try to install any other package or …

mysql ubuntu-16.04 apt-get mysql-5.7

Invalid JSON text in argument 2 - json_contains in MySQL 5.7.8

I have a database with one column that is JSON of strings (ex. ["ART","LIT"], etc.). I want to search …

mysql json mysql-5.7

Homebrew, MySQL 8 support

Anyone have the inside scoop on when Homebrew will be updated to support MySQL 8's first general release (8.0.11)? I can't …

mysql version-control homebrew mysql-5.7 mysql-8.0

MySQL 5.7 show_compatibility_56

Recently, I decided to get a VPS server and host my own forums as we grew too big for your …

phpmyadmin ubuntu-16.04 mysql-5.7

How to create index on json column in MySQL?

How to create index on sub-documents in Json data type in MySQL server? I know we have to create a …

json database indexing mysql-5.7

MySQL: Invalid GIS data provided to function st_geometryfromtext

Here's my code: SET @poly = 'Polygon((-98.07697478272888 30.123832577126326, -98.07697478272888 30.535734310413392, -97.48302581787107 30.535734310413392, -97.48302581787107 30.123832577126326))'; SELECT name FROM county_shapes WHERE MBRContains(ST_GeomFromText(@…

mysql gis spatial-index mysql-5.7

Ansible Install MySql 5.7 - Set Root User Password

I've recently upgraded my vagrant from ubuntu/trusty-64 to bento/ubuntu-16.04. With that MySQL was updated to 5.7. I've made several …

mysql ansible ubuntu-16.04 mysql-5.7

How to resolve "specified key was too long max key length is 255 bytes" in mysql?

Whenever i fire this query from one of the mysql client (emma): CREATE TABLE `tbl_mappings` ( `id` int(11) unsigned NOT …

mysql database innodb mysql-5.7 my.cnf