MYSQL code execution error: FUNCTION any_value does not exist

Question

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?

Answer 1

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☺️

Answer 2

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