开发者

Mysql column to utf8_bin

I have a table in mysql. I want to change one of the columns to have utf8_bin as it's collate attribute. I know the command to do for whole table is like: ALTER TABLE temp CONVERT TO CHARACTER SET utf8 COLLATE utf8_bin;

But how do I do it for individual columns?

Thanks开发者_如何转开发 for the help


It's right in the manual

Their example

ALTER TABLE t1 MODIFY
    col1 VARCHAR(5)
      CHARACTER SET latin1
      COLLATE latin1_swedish_ci;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜