>
> 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!
-Govi
> From: Tim Dunphy
>
> ... 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 you
mess with *an
;t have any meaningful impact. Also previewing what you
> will be deleting by using a select is great advice I intend to use.
>
> Best
> tim
>
> - Original Message -
> From: "Paul DuBois"
> To: "Tim Dunphy"
> Cc: mysql@lists.mysql.com
> Sen
ice I intend to use.
Best
tim
- Original Message -
From: "Paul DuBois"
To: "Tim Dunphy"
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:
> hello l
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 compar
