|
From: | Eliel |
Subject: | Re: [shell-script] Re: Script mysql + CSV |
Date: | Wed, 23 Oct 2013 12:36:46 -0200 |
Fazendo direto rola :
mysql> select * from article limit 0,1 INTO OUTFILE '/tmp/sac1.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
Query OK, 1 row affected (0.00 sec)
porém ele não pega cabeçalho no arquivo CSV.
--- Em address@hidden, "Julian" <jul1ansoares@...> escreveu
>
> Aos consultores então, ve se isso faz parte de uma ajuda ou consultoria :
> teoricamente está assim :
>
> mysql -u$user -p$pass -D$banco -e select * from ticket limit 0,10 INTO OUTFILE '/tmp/sac1.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
>
> só que não rolou, desse jeito
>
[Prev in Thread] Current Thread [Next in Thread]
- Re: [shell-script] Re: Script mysql + CSV, MrBiTs, 2013/10/23
- Re: [shell-script] Re: Script mysql + CSV, MrBiTs, 2013/10/23
- Re: Script mysql + CSV, Julian, 2013/10/23
- Re: Script mysql + CSV, Julian, 2013/10/23
- Re: [shell-script] Re: Script mysql + CSV, Eliel <=
- Re: Script mysql + CSV, Julian, 2013/10/23
- Re: [shell-script] Re: Script mysql + CSV, Eliel, 2013/10/23
- [Moderação] Script mysql + CSV, shell-script-owner, 2013/10/23
- Re: [shell-script] Re: Script mysql + CSV, MrBiTs, 2013/10/23
- Prev by Date: [Moderação] Script mysql + CSV
- Next by Date: Re: Script mysql + CSV
- Previous by thread: Re: Script mysql + CSV
- Next by thread: Re: Script mysql + CSV
- Index(es):