mysqlGet default charset of a database
SELECT DEFAULT_CHARACTER_SET_NAME FROM information_schema.SCHEMATA WHERE schema_name = 'db';ctrl + cDEFAULT_CHARACTER_SET_NAMEwill select dafault charset for specified databse | information_schema.SCHEMATAsystem table with meta information for databases |
'db'name of our databse to get charset for | |
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...