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","12","13","14","15","16","17","18","19","20",
"21","22","23","24","25","26","27","28","29","30",
"31","32","33","34","35","36","37","38","39","30",
"41","42","43","44","45","46","47","48","49","40",
"51","52","53","54","55","56","57","58","59","60")
);
Add a row:
insert into test1 values (1, "40");
Then select & oops:
select var1,var2+0 from test1;
+------+---------------------+
| var1 | var2+0 |
+------+---------------------+
| 1 | 5.6294995342131e+14 |
+------+---------------------+
How can I get this output as an integer?
I've tried both MySQL 3.23 and 4.0.17 with the same result. I'm running
on linux (RHL 8.0)
Thanks
- Greg
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
