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
