Mysql delete data via cli

From thelinuxwiki
Revision as of 15:56, 12 April 2013 by Nighthawk (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

deleting range from shell

delete user_id if greater than 2

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