Mysql 如何修改字段区分大小写

# mysql–u root–p

Ø Show databases;

Ø User数据库名称。

Ø Desc t_user

Ø ALTER TABLETABLENAMEMODIFY COLUMNCOLUMNNAMETPYE BINARY CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL;