shell-script-pt
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[no subject]

>From address@hidden Wed Oct 23 05:42:53 2013
Return-Path: <address@hidden>
X-Sender: address@hidden
X-Apparently-To: address@hidden
X-Received: (qmail 96485 invoked by uid 102); 23 Oct 2013 12:42:52 -0000
X-Received: from unknown (HELO mtaq3.grp.bf1.yahoo.com) (10.193.84.142)
  by m12.grp.bf1.yahoo.com with SMTP; 23 Oct 2013 12:42:52 -0000
X-Received: (qmail 18366 invoked from network); 23 Oct 2013 12:42:52 -0000
X-Received: from unknown (HELO ng11-vm0.bullet.mail.bf1.yahoo.com) 
(98.139.164.52)
  by mtaq3.grp.bf1.yahoo.com with SMTP; 23 Oct 2013 12:42:52 -0000
X-Received: from [98.139.164.121] by ng11.bullet.mail.bf1.yahoo.com with NNFMP; 
23 Oct 2013 12:42:52 -0000
X-Received: from [10.193.94.106] by tg2.bullet.mail.bf1.yahoo.com with NNFMP; 
23 Oct 2013 12:42:52 -0000
Date: Wed, 23 Oct 2013 12:42:50 -0000
To: address@hidden
Message-ID: <address@hidden>
In-Reply-To: <address@hidden>
User-Agent: eGroups-EW/0.82
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Mailer: Yahoo Groups Message Poster
X-Yahoo-Newman-Property: groups-compose
X-Originating-IP: 187.64.250.172
X-eGroups-Msg-Info: 2:3:4:0:0
X-Yahoo-Post-IP: 187.64.250.172
From: "Julian" <address@hidden>
Subject: Re: Script mysql + CSV
X-Yahoo-Group-Post: member; u=443799269; 
y=wldlprCt_YtVLBI4VnWnKBin9jOtD-pzJM8DYB9QgUk4EmkwmrY7
X-Yahoo-Profile: jul1ansoares

Eu fiz assim :=20

mysql> select * from ticket,users limit 0,10 INTO OUTFILE '/tmp/sac1.csv' F=
IELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'=
;


por=E9m preciso rever o select, preciso pegar todas as info, e assim s=F3 e=
stpa vindo as informa=E7=F5es, sem os titulos de 'id''name''ticket number' =
etc...

--- Em address@hidden, MrBiTs <mrbits.dcf@...> escreveu
>
> On 10/23/2013 09:59 AM, Julian wrote:
> > MrBits, poderia me ajudar com essa tarefa?
> >=20
> > na vdd pensei em script, pq preciso exportar os arquivos toda semana.
>=20
> Obviamente, o script vai te ajudar a automatizar a tarefa, podendo inclus=
ive ser jogado na crontab e executado automaticamente,
> digamos, =E0s 8:00 da manh=E3 da segunda-feira, e ele pode ser composto b=
asicamente de duas linhas: o shabang e o comando mysql em s=ED.
>=20
> Voc=EA pode tanto utilizar INTO OUFILE e definir os delimitadores, redire=
cionando a sa=EDda para um arquivo.csv ou pode fazer um pipe
> para o tr "\t" ";", trocando o separador padr=E3o (TAB) da descarga do cl=
iente mysql por ponto-e-v=EDrgula. Basicamente, um mysql -N -e
> "QUERY", sendo query um SELECT que se utiliza do INTO OUTFILE, resolve o =
seu problema.
>=20
> A quest=E3o =E9: voc=EA sabe qual =E9 a query que voc=EA vai ter que roda=
r ? Sabe pelo menos utilizar o cliente do mysql ? Se realmente n=E3o
> souber essas duas coisas, n=E3o temos como te ajudar, a n=E3o ser que voc=
=EA queira me contratar para uma consultoria.
>=20
> --=20
>=20
> LLAP
>=20
> .0. MrBiTs - mrbits.dcf@... .'.
> ..0 GnuPG  - http://keyserver.fug.com.br:11371/pks/lookup?op=3Dget&search=
=3D0x6EC818FC2B3CA5AB
> 000 http://www.mrbits.com.br
>
reply via email to
From: Unknown
[Prev in Thread] Current Thread [Next in Thread]