cast(var2 as unsigned) |
> +--++
> |1 |562949953421312 |
> |1 | 1 |
> |1 | 32768 |
> +--++
> 3 rows in set (0.00 sec)
>
> Note I add a row with "1" and another with "16"
. Do you know if
there is a way to set the number of characters in a numeric response?
On Fri, 2004-02-06 at 12:54, Michael Stassen wrote:
> Why are you adding 0? Try this:
>
>SELECT var1, var2 FROM test1;
>
> Michael
>
> Greg Vines wrote:
>
> > I'm t
I'm trying to select all the fields from a set but when the number is
large, it is returned in exponential notation. Is there a way to keep
the returned number an integer?
Example:
create simple table:
create table test1(
var1 int,
var2 set("1","2","3","4","5","6","7","8","9","10",
"11
