Good afternoon, I'm trying to get the data from a query to a .csv file and I can not get it to work. Here I put my code. Thanks
SELECT CAST(avg(numero) as decimal(18,2)) as media FROM (
SELECT
DATE(fecha_creacion) fecha_creacion,
COUNT(*) as numero
FROM paqueteria.paquetes
into outfile 'C:\Users\DANIEL\Desktop\prueba.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
WHERE
fecha_creacion BETWEEN '2017-10-01' AND '2017-10-31'
/*and hour(fecha_creacion) <= '12'*//*mañana*/
/*and hour(fecha_creacion) >= '12'*//*tarde*/
and remitente = 73
GROUP BY DATE(fecha_creacion)) as medias
I am marked as invalid line 5 and line 10