mysqlGet default charset of a table
SELECT TABLE_COLLATION FROM information_schema.tables WHERE table_name = 'table' AND table_schema = 'db';ctrl + cTABLE_COLLATIONwill show default collation for specified table | information_schema.tablessystem table with meta information for tables |
'table'name of our table | 'db'name of our databse |
More of Mysql
- Truncate all tables in a specific database
- Disable ONLY_FULL_GROUP_BY mode
- Insert/update multiple rows in single query
- How to find my.cnf config file
- Get largest tables list
- Export database tables structure without data
- Rename table column
- Skip certain tables while doing dump
- Replace string with regex
- How to find duplicate varchar/text column values in table
See more codes...