lucascaton/mysql-commands.md

Forked from duderamos/mysql-commands.md

Created May 11, 2017 04:33

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/lucascaton/cb4269029d75b21bd018617a2d65a683.js"></script>
Save lucascaton/cb4269029d75b21bd018617a2d65a683 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

mysql-commands.md

MySQL commands

Show table collation from a database:

show table status from <database>;

Show collation from an entire database;

select default_character_set_name from information_schema.schemata s where schema_name = '<database>';

Show column collcation:

show full columns from <table>;

Alter charset and collation of a database:

alter database <database> character set utf8 collate utf8_unicode_ci;

Alter charset and collation of a table:

alter table <table> convert to character set utf8 collate utf8_unicode_ci;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment