Darren Sweeney writes:
> Hi
>
> If I use SELECT COUNT(*) FROM tbl_name how do I return that as a printable string?
>
> also,
>
> if I have data such as the following
>
> id | name | number
> 1 | Ted | 36
> 1 | Ted | 36
>
> Thanks
>
> Darren
Hi!
COUNT returns result as any other integer. MySQL, however will return
it in string form, so no special transforms are required. For your
table, you will of course get a result of two.
Sinisa
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == [EMAIL PROTECTED] |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
