Difference between revisions of "Mysql delete data via cli"
From thelinuxwiki
(Pushed from Themanclub.) |
(→deleting range from shell) |
||
| Line 2: | Line 2: | ||
== deleting range from shell == | == deleting range from shell == | ||
delete user_id if greater than 2 | delete user_id if greater than 2 | ||
| − | mysql -h localhost -u root | + | 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. | ||
[[category:mysql]] | [[category:mysql]] | ||
Revision as of 01:19, 13 April 2014
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.
