blob: 97c492ff282d37be9490501137cfb9ba712309ae (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
# This document has some useful SQL tricks
* Check the character set/collation a given table uses:
```
SELECT CCSA.* FROM information_schema.`TABLES` T,
information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA
WHERE CCSA.collation_name = T.table_collation
AND T.table_schema = "db_webqtl"
AND T.table_name = "Investigators";
```
|
