の履歴(No.1)

• 履歴一覧
• 差分 を表示
• 現在との差分 を表示
• ソース を表示
• へ行く。
  • 1 (2012-08-04 (土) 19:27:49)
  • 2 (2012-08-04 (土) 19:33:26)
  • 3 (2014-06-07 (土) 02:38:33)
  • 4 (2016-04-02 (土) 13:59:01)
  • 5 (2016-04-13 (水) 15:50:03)

hidekiwiki

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;

1. --------------------------------------------+-------------+

   CONCAT_WS('@',mail.mail_name,domains.name)

   password

2. --------------------------------------------+-------------+

   [email protected]
   [email protected]
   [email protected]
   [email protected]

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