Linux DB PHP Scripts Tech Diary
Search This Blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment