Wednesday, March 16, 2011

Run MySQL SQL queries on Linux command line

This is a shell script

#!/bin/bash

deletelist="delete from capture_files where date(updated_on) < DATE_SUB(CURdate(), INTERVAL 30 DAY);"

mysql -u dbuser -pdbpasswd amp -e "$deletelist"

No comments:

Post a Comment