开发者

How can I select columns with specific collation from mysql?

I wondering how can I select columns with specific collation.

For example, I want to select all the columns which their collation is utf-8.

How can I get these things done开发者_如何学C?

Thanks very much!


SHOW FULL COLUMNS is what you need:

SHOW FULL COLUMNS FROM xxx WHERE COLLATION = 'utf8_general_ci'
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜