Re: Alter table add index returning "rows affected"

[Sunny Bains]

Stewart Smith wrote:
> On Tue, 2006-12-19 at 21:57 +1100, Sunny Bains wrote:
>>>> I want to return the number of "rows affected" for the alter table
>>>> like below:
>>>>
>>>>   mysql> alter table t1 add index i1(c1);
>>>>   Query OK, 0 rows affected (0.02 sec)
>>>>   Records: 0  Duplicates: 0  Warnings: 0
>>>>
> 
>> Perhaps I should have been more clear, I meant returning the number of
>> rows affected from file->add_index(), after creating the index(es).
> 
> For NDB and online add index, we return 0 rows affected to indicate that
> it was not a copying alter table.

OK, makes sense for "rows affected" but what about "Records:"  ?