Mysql delete data via cli - Revision history

Nighthawk at 22:10, 8 February 2015

2015-02-08T22:10:43Z

Nighthawk: /* deleting range from shell */

2014-04-13T01:19:55Z

‎deleting range from shell

Nighthawk: Pushed from Themanclub.

2013-04-12T15:56:39Z

Pushed from Themanclub.

New page

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

[[category:mysql]]

← Older revision		Revision as of 22:10, 8 February 2015
Line 5:		Line 5:

	the above command was used to delete everything but the admin user.		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;

	[[category:mysql]]		[[category:mysql]]

@@ Line 2: / Line 2: @@
 == 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
+  mysql -h localhost -u root mediawikidb -e "DELETE FROM thelinuxwiki_user WHERE user_id > '2'" --password=password
 [[category:mysql]]