On Sat, Dec 23, 2017 at 10:03 PM, Martin Domdey animalia@gmx.net wrote:
Hi!
Does anybody now, what a database table contains a column containing all the interwiki languages existing like 'dewiki', 'enwiki' , 'frwiki', ...
The meta_p `wiki` table may be what you are looking for:
$ sql meta Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 25438936 Server version: 10.1.29-MariaDB MariaDB Server
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
(u3518@s7.labsdb) [meta_p]> describe wiki; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | dbname | varchar(32) | NO | PRI | NULL | | | lang | varchar(12) | NO | | en | | | name | text | YES | | NULL | | | family | text | YES | | NULL | | | url | text | YES | | NULL | | | size | decimal(1,0) | NO | | 1 | | | slice | text | NO | | NULL | | | is_closed | decimal(1,0) | NO | | 0 | | | has_echo | decimal(1,0) | NO | | 1 | | | has_flaggedrevs | decimal(1,0) | NO | | 0 | | | has_visualeditor | decimal(1,0) | NO | | 0 | | | has_wikidata | decimal(1,0) | NO | | 0 | | | is_sensitive | decimal(1,0) | NO | | 0 | | +------------------+--------------+------+-----+---------+-------+ 13 rows in set (0.00 sec)
(u3518@s7.labsdb) [meta_p]> select * from wiki where dbname='enwiki'\G *************************** 1. row *************************** dbname: enwiki lang: en name: Wikipedia family: wikipedia url: https://en.wikipedia.org size: 3 slice: s1.labsdb is_closed: 0 has_echo: 1 has_flaggedrevs: 1 has_visualeditor: 1 has_wikidata: 1 is_sensitive: 0 1 row in set (0.00 sec)
Bryan