mysqlGet default charset of a column
SELECT character_set_name FROM information_schema.columns WHERE table_schema = 'db' AND table_name = 'table' AND column_name = 'column';ctrl + ccharacter_set_namewill show charset for specified column | information_schema.columnssystem table with meta information for columns of all tables |
'db'name of our databse | 'table'name of our table |
'column'name of our column | |
More of Mysql
- Insert/update multiple rows in single query
- Disable ONLY_FULL_GROUP_BY mode
- How to find my.cnf config file
- Get largest tables list
- Truncate all tables in a specific database
- How to find duplicate varchar/text column values in table
- What is the MEDIUMTEXT column max size (length) in Mysql
- Skip certain tables while doing dump
- What is the LONGTEXT column max size (length) in Mysql
- What is the TINYINT column max value and size in Mysql
See more codes...