|
|
Posted by dummie on 10/12/71 11:38
On Sat, 28 Jan 2006 19:28:49 +0100, "J.O. Aho" <user@example.net>
wrote:
>dummie wrote:
>> I've got brain free at the moment.
>>
>> But how do I convert an integer into a decimal ie
>> 1 beomes 1.00
>>
>> This has come about because when I converted my Access database into
>> MySQL it change all the decimal valvues into integers.
>>
>
>ALTER TABLE yourtablename MODIFY yourcolumnname FLOAT;
>
>
>
> //Aho
I have tried formating the particular field in the Access database,
but it always reverts to a 'double' value when I convert to mysql.
Any ideas, as I want to do it directly from the Access dbase or via
php code.
Navigation:
[Reply to this message]
|