Clarify your question ... are you trying to drop TABLES, DATABASES, or
modify user privileges?
If you are trying to modify user privileges, use GRANT or REVOKE.
- Original Message -
From: "Daniel Curry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 10, 2002 6:26 PM
Paul,
Thank you. That did it.
You are correct I needed to DELETE.
Paul DuBois wrote:
>
> At 16:26 -0700 9/10/02, Daniel Curry wrote:
> > I am unable to find the specific DROP command to remove only test@%,
> >test\_%@%,
> >snort@localhost, and snort@%.
>
> I think you want DELETE, not DRO
At 16:26 -0700 9/10/02, Daniel Curry wrote:
> I am unable to find the specific DROP command to remove only test@%,
>test\_%@%,
>snort@localhost, and snort@%.
I think you want DELETE, not DROP.
DELETE FROM db WHERE Db='test' AND Host='%';
DELETE FROM db WHERE Db='test\_' AND Host='%';
DELETE FR
