Select * from myTable PROCEDURE ANALYSE() - Strange result...
Hello,
I'm running a Select * from myTable procedure analyse(); and I get a strange result for some fields.
Field_Name: myDB.myTable.myField
Min_Value: -9029.12
Max_value: 19503.71
...
...
Optimal_fieldtype: Decimal(12,2) UNSIGNED NOT NULL
How can MySQL recommend me having the field UNSIGNED while the min value is -9029.12 and I have plenty of negative values in my table.. Kind of weird isn't ?
Subject
Written By
Posted
Select * from myTable PROCEDURE ANALYSE() - Strange result...
July 26, 2005 02:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.