MySQL CLI Question

[Michael MacDonald]

I would like to use CLI to extract from MySQL a list of all user accounts and associated domains.

Does anyone know this command?

Thank you in advance.

 

[IgorG]

Try to use something like:

mysql> select mail_name,name from mail left join domains on mail.dom_id = domains.id inner join accounts where mail.account_id = accounts.id order by name asc;