Table Data Type Alter

Question

I created a table named items and inserted name as int and provided the length as 255 type by mistake but now i wanted to alter the table structure and run the query as--

ALTER TABLE items ALTER COLUMN name varchar(255); but it is not altering the table what i need to change in the table.help plz

score 22 · Accepted Answer · answered May 27 '11 at 07:15

22

there are two ways

ALTER TABLE t1 CHANGE <column_name> <column_name> <type>

note: you have to write column name twice OR

ALTER TABLE t1 MODIFY <column_name> <type> ;

Reference

answered May 27 '11 at 07:15

xkeshav

53,360
44
177
245

bro..just tell me how do i vote its says u need 15 credits to vote – swapnesh May 27 '11 at 07:38
Yes; wait and ask more question or answers others. when u acquire **15** reputation then upvote me :) – xkeshav May 27 '11 at 07:41

score 2 · Answer 2 · answered May 27 '11 at 07:12

2

try:

alter table t1 modify column name varchar(255);

answered May 27 '11 at 07:12

neocanable

5,293
2
23
28

score 1 · Answer 3 · answered May 27 '11 at 07:16

1

Try:

ALTER table items
MODIFY name varchar(255);

answered May 27 '11 at 07:16

royrui

1,217
10
20

Table Data Type Alter

3 Answers3

Reference

Linked