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]
