List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:June 9 1999 4:57am
Subject:Re: Strange console
View as plain text  
Michael Farr wrote:
> 
> Does anyone know why when I delete this function it says 0 rows affected?
> 
> mysql> select * from func;
> +---------+-----+------------+----------+
> | name    | ret | dl         | type     |
> +---------+-----+------------+----------+
> | balance |   1 | balance.so | function |
> | accum   |   1 | accum.so   | function |
> +---------+-----+------------+----------+
> 2 rows in set (0.00 sec)
> 
> mysql> drop function balance;
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> select * from func;
> +-------+-----+----------+----------+
> | name  | ret | dl       | type     |
> +-------+-----+----------+----------+
> | accum |   1 | accum.so | function |
> +-------+-----+----------+----------+
> 1 row in set (0.00 sec)
> 

Mike:

Life is hard, that's all I can say. When you drop a table, MySQL thinks
that no rows were affected. I guess there is a bit of truth to this,
since no individual rows were processed, all just went too fast into the
blackhole to count them :)

-- 
Sasha Pachev
http://www.sashanet.com
Thread
Strange consoleMichael Farr9 Jun
  • Re: Strange consoleSasha Pachev9 Jun
  • Strange consoleMichael Widenius9 Jun