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 /topics/next-gen-databases/sql-tricks.gmi | |
| 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>
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"; +``` |