G'Day All;
MySQL on RedHat 9
working completely from the command prompt. I am so newbie I am
embareassed.
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 |
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
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 tablename modify columnname double(3,2) unsigned
zerofill, etc.
The MySQL docs are not