Re: Question about dump on MySQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



great!!

 thank for your answers, it is very useful for me

Regards


2014-08-11 17:33 GMT-04:00 Todor Petkov <zakk@xxxxxxxxx>:

> On 11/08/2014 11:10 PM, Rodrigo Pichiñual Norin wrote:
> > I need export an registers of a data base from command line.
> >
> > It is possible with mysqldump?
> >
> > for example:
> >
> > mysqldump -u user -ppass db "select *from users where id=20" ???
> >
> >
> > thank
>
>
> Hi,
>
> as I understand, you need to apply a 'WHERE' clause? It can be done like
> this:
>
> mysqldump database table_bame --where="date_column BETWEEN '2012-07-01
> 00:00:00' and '2012-12-01 00:00:00'"
>
>
>
> Keep in mind, that this clause is valid only for table. I am not sure if
> you can use JOIN.
>
>
> Regards,
>
>
> _______________________________________________
> CentOS mailing list
> CentOS@xxxxxxxxxx
> http://lists.centos.org/mailman/listinfo/centos
>
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos





[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux