diff options
Diffstat (limited to 'topics/next-gen-databases/sql-tricks.gmi')
-rw-r--r-- | topics/next-gen-databases/sql-tricks.gmi | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/topics/next-gen-databases/sql-tricks.gmi b/topics/next-gen-databases/sql-tricks.gmi new file mode 100644 index 0000000..97c492f --- /dev/null +++ b/topics/next-gen-databases/sql-tricks.gmi @@ -0,0 +1,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"; +``` |