[es] - rezultat MySQL upita u txt fajl?

fimalbonegaculo
Igor Milovanović
developer, sys-admin
beograd

Član broj: 395
Poruke: 158
62.41.25.*

ICQ: 81662016
Sajt: www.linkedin.com/in/igorm..

Profil

rezultat MySQL upita u txt fajl?

^{02.02.2003. u 20:16}

Znam da zvuči kao „čocječe, pa gdje ti živiš“, ali gori mi pod nogama, a nisam baš jaaaako vičan kucanju MySQL upita.

Znači treba mi da uradim jedan SELECT i da mi on rezultat izbaci u txt fajl! Upi nije problem, sasvim je jednostavan, ali daje mnogo rezultata, pa mi treba da ga posle less-ujem.

Povezan sam na MySQL server sve ok, po linuxom i tako to... znači samo kao neka cijev (|) il slicno!

HVALA!

"if you fail to plan, you plan to fail"

^{02.02.2003. u 20:16}

fimalbonegaculo
Igor Milovanović
developer, sys-admin
beograd

Član broj: 395
Poruke: 158
62.41.25.*

ICQ: 81662016
Sajt: www.linkedin.com/in/igorm..

Profil

Re: rezultat MySQL upita u txt fajl?

^{02.02.2003. u 20:40}

Našao sam rješenje....

Code:

SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]
select_expression,...
[INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
[FROM table_references
[WHERE where_definition]
[GROUP BY {unsigned_integer | col_name | formula} [ASC | DESC], ...]
[HAVING where_definition]
[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
[LIMIT [offset,] rows]
[PROCEDURE procedure_name]
[FOR UPDATE | LOCK IN SHARE MODE]]

http://www.mysql.com/doc/S/E/SELECT.html
-------------------------------------------------------
SELECT a,b,a+b INTO OUTFILE "/tmp/result.text"
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY "\n"
FROM test_table;

jedimo me zeza nešto kao ovaj korisnik nema pristupa ... al rješit ću i to...

"if you fail to plan, you plan to fail"

^{02.02.2003. u 20:40}