Delete mysql table data (Bash Script)

Question

I was wondering how to delete the values in a MySQL database table from bash.

I have a database called "database" and a table in that database called "table".

Now I want to dump and clear the database from a bash script.

How can I delete the values?

I am using:

mysqldump database > $DB_BACKUP/01/table-`date +%Y-%m-%d` (to dump)

and now trying to

DELETE FROM database.table WHERE filed < CURDATE()-5

Jacek Kaniuk · Accepted Answer · 2011-08-23 10:59:46Z

13

mysql -Bse 'DELETE FROM database.table WHERE filed < CURDATE()- 5'

or

mysql -Bse 'DELETE FROM table WHERE filed < CURDATE()- 5' database

mysql --help

-B, --batch Don't use history file. Disable interactive behavior. starts with this option ENABLED by default! Disable with

-s, --silent Be more silent. Print results with a tab as separator, Buffer for TCP/IP and socket communication

-e, --execute=name Execute command and quit. (Disables --force and history file)

answered Aug 23, 2011 at 10:43

Jacek Kaniuk

5,22928 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Could i know what is -Bse Please

i've added that to my response