Differenze tra le versioni di "MySql:SELECT INTO OUTFILE, con UNION"
(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 ((...") |
(Nessuna differenza)
|
Versione attuale delle 08:28, 25 set 2024
fonte: https://dba.stackexchange.com/questions/19899/mysql-select-into-outfile-with-a-union
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";
