|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
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? |
|
#2
|
|||
|
|||
|
ALTER table table_name
MODIFY userid varchar(40); |
|
#3
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|