: delete all hosts using a wildcard
On Jan 14, 2012, at 5:23 PM, Tim Dunphy wrote:
hello list,
I have a number of hosts that I would like to delete using a wildcard
(%) symbol.
Here is the query I am using:
mysql delete from mysql.user where user='%.summitnjhome.com';
Couple
From: Tim Dunphy bluethu...@jokefire.com
... this is just a test environment so getting rid of those users won't have
any meaningful impact...
I think what Paul (who wrote a book on MySQL, by the way) was getting at was
that you risk what database folk call referential integrity issues if
I think what Paul (who wrote a book on MySQL, by the way) was getting at was
that you risk what database folk call referential integrity issues if you
mess with *any* data without knowing where else it is used.
[snip]...
that was really an important post, excellently written!
-Govinda
--
On Jan 14, 2012, at 5:23 PM, Tim Dunphy wrote:
hello list,
I have a number of hosts that I would like to delete using a wildcard (%)
symbol.
Here is the query I am using:
mysql delete from mysql.user where user='%.summitnjhome.com';
Couple of things:
* You want to compare your
intend to use.
Best
tim
- Original Message -
From: Paul DuBois paul.dub...@oracle.com
To: Tim Dunphy bluethu...@jokefire.com
Cc: mysql@lists.mysql.com
Sent: Saturday, January 14, 2012 6:46:38 PM
Subject: Re: delete all hosts using a wildcard
On Jan 14, 2012, at 5:23 PM, Tim Dunphy wrote