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
- How to find my.cnf config file
- Make a pager (limit / offset) select query
- Get largest tables list
- Truncate all tables in a specific database
- Insert new values only if row doesn't exist already
- What is the MEDIUMTEXT column max size (length) in Mysql
- How to find duplicate varchar/text column values in table
- Skip certain tables while doing dump
- Select first record from group
- Select last record from group
See more codes...