<cut>
Michael> what I would like to see is this
mysql> select * from acctest;
Michael> +----------+
Michael> | debit |
Michael> +----------+
Michael> +----------+
Michael> 0 rows in set (0.00 sec)
Michael> (note, it reads 0 rows in set, not Empty set)
Michael> On the other hand, I think that this is only a result of using command line
Michael> mysql, and MySQL actually does return column information. I haven't
Michael> confirmed this yet.
Yes, mysqld always return the column information! It's 'mysql' that
strips the output in this case.
Regards,
Monty