Hi,
The following command returns recommended type FLOAT(3,6) for a
double(10,6) column:
mysql CAT -t -u catadmin -p -e \
"select * from temp procedure analyse(16,8192)" > temp.log
Optimal_fieldtype = FLOAT(3,6) NOT NULL.
The trouble is that FLOAT(3,6) does not make sense, with FLOAT(M,D),
M > D+2 should hold.
Is procedure analyse(16,8192) old? Or I am doing sth wrong?
I have MySQL 5.0.22 under FC3 Linux on AMD64bit.
Cheers
Gaspar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
