Posted by dummie on 10/11/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.

[Back to original message]