Nested select with an insert to create multiple rows — used this to add admin privileges for a client in Maia for all their domains:
INSERT INTO maia_domain_admins (SELECT t2.domain_id,1013 from postfix_transport t2 WHERE t2.mta_host='1.2.3.4');Nested select with an insert to create multiple rows — used this to add admin privileges for a client in Maia for all their domains:
INSERT INTO maia_domain_admins (SELECT t2.domain_id,1013 from postfix_transport t2 WHERE t2.mta_host='1.2.3.4');
Comments are closed.