hidekiwiki


ˤ֥ۤ¼ ɣԵѥ֥ Linux
ˤ֥ۤ¼

mysql -u admin -p`cat /etc/psa/.psa.shadow`
use psa;
SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password
FROM domains,mail,accounts 
WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id 
ORDER BY domains.name ASC,mail.mail_name ASC;

+--------------------------------------------+-------------+
| CONCAT_WS('@',mail.mail_name,domains.name) | password    |
+--------------------------------------------+-------------+





+--------------------------------------------+-------------+
5 rows in set (0.00 sec)

トップ   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2016-05-21 (土) 01:54:37 (1067d)