>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 always that easy to wade through but they do have information and examples for such things. There are a couple of good sites you can visit on the web for basic SQL instruction: http://sqlzoo.net http://sqlcourse.com http://www.w3schools.com/sql/ http://www.firstsql.com/tutor.htm http://www.geocities.com/paikiran/articles/index.html -- John A. Sullivan III Chief Technology Officer Nexus Management +1 207-985-7880 [EMAIL PROTECTED] --- If you are interested in helping to develop a GPL enterprise class VPN/Firewall/Security device management console, please visit http://iscs.sourceforge.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]