How to extract data from a MYSQL query in .csv

0

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

    
asked by hayber 26.10.2017 в 17:13
source

0 answers