On Sat, Dec 23, 2017 at 10:03 PM, Martin Domdey <[email protected]> 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. ([email protected]) [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) ([email protected]) [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 -- Bryan Davis Wikimedia Foundation <[email protected]> [[m:User:BDavis_(WMF)]] Manager, Cloud Services Boise, ID USA irc: bd808 v:415.839.6885 x6855 _______________________________________________ Wikimedia Cloud Services mailing list [email protected] (formerly [email protected]) https://lists.wikimedia.org/mailman/listinfo/cloud
