Mysql delete data via cli

deleting range from shell

delete user_id if greater than 2

mysql -h localhost -u root mediawikidb -e "DELETE FROM thelinuxwiki_user WHERE user_id > '2'" --password=password

the above command was used to delete everything but the admin user.

delete all transactions in gnucash

> DELETE FROM transactions WHERE guid IS NOT NULL;