Andrea: Creata pagina con "← Torna a MySQL Category:MySQL fonte: https://dba.stackexchange.com/questions/19899/mysql-select-into-outfile-with-a-union

 SELECT * FROM ((..."

2024-09-25T08:28:22Z

Creata pagina con "← Torna a MySQL Category:MySQL fonte: https://dba.stackexchange.com/questions/19899/mysql-select-into-outfile-with-a-union <pre> SELECT * FROM ((..."

Nuova pagina

[[GENERALE#MySQL|← Torna a MySQL]] [[Category:MySQL]]

fonte: https://dba.stackexchange.com/questions/19899/mysql-select-into-outfile-with-a-union

<pre>
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";
</pre>

MySql:SELECT INTO OUTFILE, con UNION - Cronologia

Andrea: Creata pagina con "← Torna a MySQL Category:MySQL fonte: https://dba.stackexchange.com/questions/19899/mysql-select-into-outfile-with-a-union
SELECT * FROM ((..."