What command do I use to change the field type in my client_info table
from:
referral_percent | tinyint(4) | YES | NULL
to
referral_percent | double(3,2) unsigned zerofill | YES | NULL
ALTER TABLE yourtable CHANGE referral_percent referral_percent double(3,2)
unsigned zerofill default null;
Jeremy,
Thanks very much. 'preciate it.
-Original Message-
From: Jeremy March [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 8:46 AM
To: [EMAIL PROTECTED]
Subject: Re: Changing field type
What command do I use to change the field type in my client_info table
from