I am replicating a linux server database on my laptop, but in the queries it occurs an error that #1305 - FUNCTION ANY_VALUE does not exist
whose query I did myself in servidor linux
which runs without problems, I just installed the version of xampp 3.2.2
and phpmyadmin 4.8.4
which is more recent and was included in XAMPP
.
SELECT
estado AS estado,
ANY_VALUE(ano) AS ano,
ANY_VALUE(fecha) AS NAME
FROM
(
SELECT
f.estadoF AS estado,
YEAR(p.fechaP) AS ano,
MONTHNAME(p.fechaP) AS fecha
FROM
pagos p
INNER JOIN factura f ON
p.idFactura = f.idFactura
WHERE
(f.estadoF = 'Pagado') AND(
p.fechaP BETWEEN '2018-01-01' AND '2018-12-31'
)
GROUP BY
p.fechaP
) pagos
GROUP BY
mes
Regarding the versions of MySQL
on the server is MySQL 5.7.*
and XAMPP
is MariaDB 10.1.*
which works fine, but does not recognize ANY_VALUE()
.
Any suggestions for Update or Optimize judgment?