summaryrefslogtreecommitdiff
path: root/topics
diff options
context:
space:
mode:
Diffstat (limited to 'topics')
-rw-r--r--topics/next-gen-databases/ontology.gmi1
-rw-r--r--topics/next-gen-databases/sql-tricks.gmi11
2 files changed, 12 insertions, 0 deletions
diff --git a/topics/next-gen-databases/ontology.gmi b/topics/next-gen-databases/ontology.gmi
index a028dbc..35a87bf 100644
--- a/topics/next-gen-databases/ontology.gmi
+++ b/topics/next-gen-databases/ontology.gmi
@@ -9,6 +9,7 @@ Here, we note down all lessons learnt while we continuously improve our ontologi
=> https://www.w3.org/wiki/VocabularyMarket Vocabulary Market
=> https://www.w3.org/TR/prov-o/ PROV-O: The PROV Ontology
=> https://bioportal.bioontology.org/ontologies Browse Ontologies related to biology
+
### rdfs:label
Consider this pattern when dumping data in rdf:
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";
+```