jueves, 16 de marzo de 2017

mysql from command line and cron job


delete  all records every day at 2 AM

0 2 * * *  /usr/bin/mysql -h 127.0.0.1  --user=root --password='' --skip-column-names conferences  -e " select *  from listeners"



/usr/bin/mysql -h 127.0.0.1  --user=root --password='' --skip-column-names conferences  -e " delete  from listeners where ID=5"

No hay comentarios:

Publicar un comentario