Início / dba / Perguntas / 19899
Accepted
Mike Purcell
Asked: 2012-06-26 12:43:22 +0800 CST

MySQL - SELECT INTO OUTFILE, com um UNION

  • 772

É possível emitir várias consultas de seleção cujos conjuntos de resultados são combinados via união, no mesmo arquivo de saída?

O que estou tentando fazer, mas não está funcionando:

(SELECT email FROM table WHERE createdate >= date_sub(now(), interval 1 year))
UNION DISTINCT
(SELECT email FROM table WHERE createdate < date_sub(now(), interval 1 year) AND email not like '%@gmail.com')
INTO OUTFILE '/tmp/emailDump.txt' FIELDS TERMINATED BY "," LINES TERMINATED BY "\n";
mysql union

1 respostas

  1. Best Answer

    Experimente

    SELECT * FROM
((SELECT email FROM table WHERE createdate >= date_sub(now(), interval 1 year))
UNION DISTINCT
(SELECT email FROM table WHERE createdate < date_sub(now(), interval 1 year) AND email not like '%@gmail.com')) A
INTO OUTFILE '/tmp/emailDump.txt' FIELDS TERMINATED BY "," LINES TERMINATED BY "\n";
    • 5

relate perguntas