Properly ALTER Column Data?

2010-03-11 Thread Carlos Mennens
I know this is very basic for most on the list but I need some MySQL help. I am logged into my database and I successfully changed a 'field type' from INT to VARCHAR. Now I need to modify the actual data I inserted into those specific fields. I checked the manual and could not really gather

RE: Properly ALTER Column Data?

2010-03-11 Thread Gavin Towey
Please read the tutorial, let us know if you have questions on the information in it: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html -Original Message- From: Carlos Mennens [mailto:carlosw...@gmail.com] Sent: Thursday, March 11, 2010 12:44 PM To: MySQL Subject: Properly ALTER

Re: Properly ALTER Column Data?

2010-03-11 Thread Carlos Mennens
On Thu, Mar 11, 2010 at 3:57 PM, Gavin Towey gto...@ffn.com wrote: Please read the tutorial, let us know if you have questions on the information in it: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html Thank you very much for the link... I did: UPDATE sun SET serial = '0123456789' WHERE