미디어위키 user text 컬럼

1 개요[ | ]

미디어위키 %_user_text 컬럼

MariaDB [(none)]> SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE
    -> FROM information_schema.COLUMNS
    -> WHERE TABLE_SCHEMA='my_wiki' AND COLUMN_NAME LIKE '%_user_text'
    -> ORDER BY TABLE_NAME;
+----------------------+---------------+----------------+
| TABLE_NAME           | COLUMN_NAME   | COLUMN_TYPE    |
+----------------------+---------------+----------------+
| abuse_filter         | af_user_text  | varbinary(255) |
| abuse_filter_history | afh_user_text | varbinary(255) |
| abuse_filter_log     | afl_user_text | varbinary(255) |
| archive              | ar_user_text  | varbinary(255) |
| cu_changes           | cuc_user_text | varbinary(255) |
| cu_log               | cul_user_text | varbinary(255) |
| filearchive          | fa_user_text  | varbinary(255) |
| image                | img_user_text | varbinary(255) |
| logging              | log_user_text | varbinary(255) |
| oldimage             | oi_user_text  | varbinary(255) |
| recentchanges        | rc_user_text  | varbinary(255) |
| revision             | rev_user_text | varbinary(255) |
+----------------------+---------------+----------------+
12 rows in set (0.00 sec)

SELECT m, COUNT(*) FROM (SELECT ar_user u, CONCAT(ar_user, ' - ', ar_user_text) m FROM `archive` WHERE ar_user != 0) A GROUP BY m ORDER BY u;
SELECT m, COUNT(*) FROM (SELECT rc_user u, CONCAT(rc_user, ' - ', rc_user_text) m FROM `recentchanges` WHERE rc_user != 0) A GROUP BY m ORDER BY u;
SELECT m, COUNT(*) FROM (SELECT rev_user u, CONCAT(rev_user, ' - ', rev_user_text) m FROM `revision` WHERE rev_user != 0) A GROUP BY m ORDER BY u;

2 같이 보기[ | ]