List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 9 1999 7:02am
Subject:Strange console
View as plain text  
>>>>> "Michael" == Michael Farr <farrm@stripped>
> writes:

Michael> Does anyone know why when I delete this function it says 0 rows affected?
mysql> select * from func;
Michael> +---------+-----+------------+----------+
Michael> | name    | ret | dl         | type     |
Michael> +---------+-----+------------+----------+
Michael> | balance |   1 | balance.so | function |
Michael> | accum   |   1 | accum.so   | function |
Michael> +---------+-----+------------+----------+
Michael> 2 rows in set (0.00 sec)

mysql> drop function balance;
Michael> Query OK, 0 rows affected (0.00 sec)

mysql> select * from func;
Michael> +-------+-----+----------+----------+
Michael> | name  | ret | dl       | type     |
Michael> +-------+-----+----------+----------+
Michael> | accum |   1 | accum.so | function |
Michael> +-------+-----+----------+----------+
Michael> 1 row in set (0.00 sec)

Hi!

'Drop function' doesn't return a count of rows in 'func'.  It returns
instead an error message if something goes wrong.

Regards,
Monty
Thread
Strange consoleMichael Farr9 Jun
  • Re: Strange consoleSasha Pachev9 Jun
  • Strange consoleMichael Widenius9 Jun