change datatype - Dev Shed

Dev Shed Forums Sponsor:

March 7th, 2000, 07:32 AM

Junior Member

Join Date: Mar 2000

Location: Hong Kong

Posts: 24

Time spent in forums: < 1 sec
Reputation Power: 0

I have already assigned a DATATYPE
eg.

userid VARCHAR(20)

now, I want to change it to VARCHAR(40)

what should i type in MySQL?

March 7th, 2000, 07:34 AM

Contributing User

Join Date: Oct 1999

Location: Annapolis, Maryland US

Posts: 113

Time spent in forums: < 1 sec
Reputation Power: 14

ALTER table table_name
MODIFY userid varchar(40);

March 7th, 2000, 07:35 AM

Junior Member

Join Date: Mar 2000

Location: Toronto, Canada

Posts: 13

Time spent in forums: < 1 sec
Reputation Power: 0

alter table TABLENAME change column userid varchar(40)

something like that. check the manual for correct syntax...

Viewing: Dev Shed Forums > Databases > MySQL Help > change datatype

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump