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]