View source for Mysql delete data via cli

← Mysql delete data via cli

Jump to: navigation, search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this page:


== 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.  

[[category:mysql]]

Return to Mysql delete data via cli.

Retrieved from "http://www.thelinuxwiki.com/index.php/Mysql_delete_data_via_cli"

Navigation menu