eptember 10, 2002 6:26 PM
Subject: need help on DROP.
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I am trying to clean up my db information.
Thank you.
m
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
I am unable to find the specific DROP command to remove only test@%,
test\_%@%,
snort@localhost, and snort@%.
I am trying to clean up my db information.
Thank you.
mysql> select * from db;
+---+--++-+-+-+-+---