On Tuesday 12 August 2014 08:15:16 Alan McRae wrote:

echo "select * from users where id=20;" | mysql -u user -ppass -Ddb

Alan McRae

On 12/08/2014 08:10, 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 _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

---

CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

No need for the pipe:

mysql -u user -p $DATABASE -e "select * from users where id=20"

NOTE: I did *not* type the password, the very fact that you can actually type the password in the command should be abolished from mysql cli

Regards

great!!

thank for your answers, it is very useful for me

Regards

2014-08-11 17:33 GMT-04:00 Todor Petkov zakk@online.bg:

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@centos.org http://lists.centos.org/mailman/listinfo/centos