MYSQL code execution error: FUNCTION any_value does not exist
iUnicorn
iUnicorn 2019-03-03 09:25:52
0
4
5062

The specific error message is as follows:

#1305 - FUNCTION any_value does not exist

The execution code is as follows:

select max(age) as max_age,class_name,any_value( name) from student1 group by class_name order by max_age desc;

mysql version 5.5.53, which is the default version of the PHP toolbox.

Please ask:

1. What is the cause of this error and how to solve it?

2. If it is a version problem, how to upgrade the mysql version of the PHP toolbox?


iUnicorn
iUnicorn

知识,成就梦想!

reply all (2)
iUnicorn

Thanks for the reply. I tried upgrading in "PHPstudy" but it didn't work. I also tried the PHP toolbox, but with no success. Could anyone please provide a tutorial on upgrading MySQL for the above two tools? Thank you very much☺️

    三言

    any_value This function should be available only in mysql5.7. You can try to write it in another way, or upgrade mysql, download the mysql installation package, and reinstall it

    • reply Thank you, I'll try again
      iUnicorn author 2019-04-07 11:35:21
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template
    About us Disclaimer Sitemap
    php.cn:Public welfare online PHP training,Help PHP learners grow quickly!