Return to Snippet

Revision: 19630
at October 27, 2009 14:01 by tobewan


Updated Code
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;

Revision: 19629
at October 27, 2009 14:00 by tobewan


Initial Code
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;

Initial URL

                                

Initial Description

                                

Initial Title
Grab Plesk domain passwords

Initial Tags
sql, server

Initial Language
Bash