Search code examples
mysqlmysql-error-1064

I have install mysql server version 5.7.9 but mysql json functions not working?

I have install mysql server version 5.7.9 but mysql json functions not working like jsn_length(),jsn_merge()..etc.

I have created a table with one field.

CREATE TABLE t1 ( 
jdoc json DEFAULT NULL 
) 
ENGINE=InnoDB DEFAULT CHARSET=latin1;

After insert data in this field with json format: "{"name": "pankaj", "lname": "kumar"}"

then I execute this query

select jsn_length(jdoc) from t1

I am getting this type error in phpmyadmin:

MySQL said: Documentation

1305 - FUNCTION jsn_length does not exist

Solution

  • I think your problem is syntax related.

    Instead of :

    select jsn_length(jdoc) from t1

    Run :

    select JSON_LENGTH(jdoc) from t1