in mysql...改一个column的属性怎样改？如果该column是primary key呢？
比方说从varchar(20)改为numeric(20)...
谢了！
小蹦请进
suppose u want to change column a in table t, from varchar(20) to numeric(20) and change its name from a to b,
u can use
ALTER TABLE t CHANGE a b numeric(20);
value in the column will be truncated, if the memory of new type is not big enough to store this value;
As for primary key, if u want to change its type from one to another, u should make sure that there won't be two duplicate value in that column after u do the transformation. otherwise, it will refuse to do the job
u can use
ALTER TABLE t CHANGE a b numeric(20);
value in the column will be truncated, if the memory of new type is not big enough to store this value;
As for primary key, if u want to change its type from one to another, u should make sure that there won't be two duplicate value in that column after u do the transformation. otherwise, it will refuse to do the job
我曾是孤单的飞鸟
飘荡在远方的天空
如今我已飞得太久
才知道我就是春天
我用力地挥动翅膀
开始寻找家的方向
我用力地挥动翅膀
溶进这宽阔的天空
Huasing Association 1999 - 2013