diff options
| author | Munyoki Kilyungi | 2023-08-08 11:49:13 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2023-08-08 11:49:13 +0300 |
| commit | 3c9091681d58c3bdb4c819c93226e66279847042 (patch) | |
| tree | 07bc4839b8299ea359c01e12d83a91b7ee7df2fd | |
| parent | 2df4b7e17e33a7a8165a584988ddf7551c7ae4b9 (diff) | |
| download | gn-gemtext-3c9091681d58c3bdb4c819c93226e66279847042.tar.gz | |
Add new document for doc'ing SQL tricks
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
| -rw-r--r-- | topics/next-gen-databases/ontology.gmi | 1 | ||||
| -rw-r--r-- | topics/next-gen-databases/sql-tricks.gmi | 11 |
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"; +``` |