Re: Changing field type

2003-11-18 Thread Jeremy March 
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;
or:
ALTER TABLE yourtable MODIFY referral_percent double(3,2) unsigned zerofill 
default null;

See:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#ALTER_TABLE
_
Send a QuickGreet with MSN Messenger 
http://www.msnmessenger-download.com/tracking/cdp_games

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Changing field type

2003-11-18 Thread Ferguson, Michael 
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:
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;
or:
ALTER TABLE yourtable MODIFY referral_percent double(3,2) unsigned
zerofill 
default null;

See:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html
#ALTER_TABLE

_
Send a QuickGreet with MSN Messenger 
http://www.msnmessenger-download.com/tracking/cdp_games


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]