Properly ALTER Column Data?

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=gcdmg-mysql-2@m.gmane.org

RE: Properly ALTER Column Data?

UGxlYXNlIHJlYWQgdGhlIHR1dG9yaWFsLCBsZXQgdXMga25vdyBpZiB5b3Ug aGF2ZSBxdWVzdGlv
bnMgb24gdGhlIGluZm9ybWF0aW9uIGluIGl0Og0KaHR0cDovL2Rldi5teXNx bC5jb20vZG9jL3Jl
Zm1hbi81LjAvZW4vdHV0b3JpYWwuaHRtbA0KDQoNCg0KLS0tLS1PcmlnaW5h bCBNZXNzYWdlLS0t
LS0NCkZyb206IENhcmxvcyBNZW5uZW5zIFttYWlsdG86Y2FybG9zd2lsbEBn bWFpbC5jb21dDQpT
ZW50OiBUaHVyc2RheSwgTWFyY2ggMTEsIDIwMTAgMTI6NDQgUE0NClRvOiBN eVNRTA0KU3ViamVj
dDogUHJvcGVybHkgQUxURVIgQ29sdW1uIERhdGE/DQoNCkkga25vdyB0aGlz IGlzIHZlcnkgYmFz
aWMgZm9yIG1vc3Qgb24gdGhlIGxpc3QgYnV0IEkgbmVlZCBzb21lIE15U1FM DQpoZWxwLiBJIGFt
IGxvZ2dlZCBpbnRvIG15IGRhdGFiYXNlIGFuZCBJIHN1Y2Nlc3NmdWxseSBj aGFuZ2VkIGEgJ2Zp
ZWxkDQp0eXBlJyBmcm9tIElOVCB0byBWQVJDSEFSLiBOb3cgSSBuZWVkIHRv IG1vZGlmeSB0aGUg
YWN0dWFsIGRhdGEgSQ0KaW5zZXJ0ZWQgaW50byB0aG9zZSBzcGVjaWZpYyBm aWVsZHMuIEkgY2hl
Y2tlZCB0aGUgbWFudWFsIGFuZCBjb3VsZA0Kbm90IHJlYWxseSBnYXRoZXIg ZXhhY3RseSBob3cg
dG8gZm9ybWF0IG15IGNvbW1hbmQuIFRoZXJlIHdhcyBqdXN0IHNvDQptYW55 IG9wdGlvbnMgYW5k
IGluZm9ybWF0aW9uIG9uIHRoZSBwYWdlLi4uDQoNCk15IHRhYmxlIGRhdGEg aXMgYXMgZm9sbG93
cyBhbmQgSSB3b3VsZCBsaWtlIHRvICdBTFRFUicgdGhlIGRhdGEgaW4NCmFs bCB0aHJlZSAnU2Vy
aWFsJyBmaWVsZHM6DQoNCm15c3FsPiBzZWxlY3QgTW9kZWwsIFNlcmlhbCwg R0ZFLCBFT0wgZnJv
bSBzdW47DQorLS0tLS0tLS0tLSstLS0tLS0tLSstLS0tLS0rLS0tLS0tLS0t LS0tKw0KfCBNb2Rl
bCAgICB8IFNlcmlhbCB8IEdGRSAgfCBFT0wgICAgICAgIHwNCistLS0tLS0t LS0tKy0tLS0tLS0t
Ky0tLS0tLSstLS0tLS0tLS0tLS0rDQp8IFVsdHJhIDI0IHwgOTQxICAgIHwg ODQwMiB8IDIwMTAt
MTAtMTYgfA0KfCA3MzEwICAgICB8IDkzNCAgICB8ICAgIDkzMTQgfCAyMDEy LTA4LTI3IHwNCnwg
SjQ0MDAgICAgfCA5MjYgICAgfCAgICA3NjIzIHwgMjAxMi0wOC0yNyB8DQor LS0tLS0tLS0tLSst
LS0tLS0tLSstLS0tLS0rLS0tLS0tLS0tLS0tKw0KMyByb3dzIGluIHNldCAo MC4wMCBzZWMpDQoN
CkNhbiBzb21lb25lIHBsZWFzZSBoZWxwIG1lIHVuZGVyc3RhbmQgaG93IEkg YW0gdG8gcHJvcGVy
bHkgdXNlIGFuZA0KY2hhbmdlIHRoZSBkYXRhIGluIE15U1FMPw0KDQotLQ0K TXlTUUwgR2VuZXJh
bCBNYWlsaW5nIExpc3QNCkZvciBsaXN0IGFyY2hpdmVzOiBodHRwOi8vbGlz dHMubXlzcWwuY29t
L215c3FsDQpUbyB1bnN1YnNjcmliZTogICAgaHR0cDovL2xpc3RzLm15c3Fs LmNvbS9teXNxbD91
bnN1Yj1ndG93ZXlAZmZuLmNvbQ0KDQoNClRoaXMgbWVzc2FnZSBjb250YWlu cyBjb25maWRlbnRp
YWwgaW5mb3JtYXRpb24gYW5kIGlzIGludGVuZGVkIG9ubHkgZm9yIHRoZSBp bmRpdmlkdWFsIG5h
bWVkLiAgSWYgeW91IGFyZSBub3QgdGhlIG5hbWVkIGFkZHJlc3NlZSwgeW91 IGFyZSBub3RpZmll
ZCB0aGF0IHJldmlld2luZywgZGlzc2VtaW5hdGluZywgZGlzY2xvc2luZywg Y29weWluZyBvciBk
aXN0cmlidXRpbmcgdGhpcyBlLW1haWwgaXMgc3RyaWN0bHkgcHJvaGliaXRl ZC4gIFBsZWFzZSBu
b3RpZnkgdGhlIHNlbmRlciBpbW1lZGlhdGVseSBieSBlLW1haWwgaWYgeW91 IGhhdmUgcmVjZWl2
ZWQgdGhpcyBlLW1haWwgYnkgbWlzdGFrZSBhbmQgZGVsZXRlIHRoaXMgZS1t YWlsIGZyb20geW91
ciBzeXN0ZW0uIEUtbWFpbCB0cmFuc21pc3Npb24gY2Fubm90IGJlIGd1YXJh bnRlZWQgdG8gYmUg
c2VjdXJlIG9yIGVycm9yLWZyZWUgYXMgaW5mb3JtYXRpb24gY291bGQgYmUg aW50ZXJjZXB0ZWQs
IGNvcnJ1cHRlZCwgbG9zdCwgZGVzdHJveWVkLCBhcnJpdmUgbGF0ZSBvciBp bmNvbXBsZXRlLCBv
ciBjb250YWluIHZpcnVzZXMuIFRoZSBzZW5kZXIgdGhlcmVmb3JlIGRvZXMg bm90IGFjY2VwdCBs
aWFiaWxpdHkgZm9yIGFueSBsb3NzIG9yIGRhbWFnZSBjYXVzZWQgYnkgdmly dXNlcyBvciBlcnJv
cnMgb3Igb21pc3Npb25zIGluIHRoZSBjb250ZW50cyBvZiB0aGlzIG1lc3Nh Z2UsIHdoaWNoIGFy
aXNlIGFzIGEgcmVzdWx0IG9mIGUtbWFpbCB0cmFuc21pc3Npb24uIFtGcmll bmRGaW5kZXIgTmV0
d29ya3MsIEluYy4sIDIyMCBIdW1ib2x0IGNvdXJ0LCBTdW5ueXZhbGUsIENB IDk0MDg5LCBVU0Es
IEZyaWVuZEZpbmRlci5jb20NCg==

Re: Properly ALTER Column Data?

On Thu, Mar 11, 2010 at 3:57 PM, Gavin Towey 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 Model = 'Ultra 24';

Worked fine!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org