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 exactly how to format my command. There was just so many options and information on the page...
My table data is as follows and I would like to 'ALTER' the data in all three 'Serial' fields: mysql> select Model, Serial, GFE, EOL from sun; +----------+--------+------+------------+ | Model | Serial | GFE | EOL | +----------+--------+------+------------+ | Ultra 24 | 941 | 8402 | 2010-10-16 | | 7310 | 934 | 9314 | 2012-08-27 | | J4400 | 926 | 7623 | 2012-08-27 | +----------+--------+------+------------+ 3 rows in set (0.00 sec) Can someone please help me understand how I am to properly use and change the data in MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org