You might get closer to what you want if you put your command in a text file and run it
from the command line.
On a Mac OS X, I put a similar command:
select count(*) from testTable;
into a small text file:
and ran this command from the Terminal:
mysql -u username -ppassword < /Users/myname/Documents/testCount.txt
The result was:
without the decorations.
On May 14, 2010, at 11:35 PM, Dan Nelson wrote:
> In the last episode (May 14), Tim Johnson said:
>> I have MySQL version 5.0.84 on linux slackware 13.0 32-bit.
>> I am working with a relatively new API written in a programming language
>> with a small user base (newlisp). The newlisp API imports a number of C
>> API functions from the system MySQL shared object.
>> If I were to issue a count(*) query from my monitor interface:
>> mysql> select count(*) from clients;
>> | count(*) |
>> | 16 |
>> If "select count(*) from clients" is issued from the newlisp API, is
>> there a a C API function that would return '16'?
> You can't do it with one function call, but you can do it, since the MySQL
> cli was able to print "16" in your example above, and it was written in C.
> Take a look at mysql_store_result(), mysql_num_fields(),
> mysql_field_count(), mysql_fetch_row(), and mysql_fetch_lengths(). There's
> a simple code fragment to print a resultset on this page:
> Dan Nelson
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1