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'
精彩评论