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?
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