Imam sledeci trigger, medjutim ne uspeva mi da dobijem zeljeni rezultat;
BEGIN
DECLARE mxRecordValue varchar(255);
SET @domainName = (SELECT name FROM domains WHERE id = NEW.id AND type='NS' LIMIT 1);
SET mxRecordValue = CONCAT('mail.',@domainName);
DELETE FROM records WHERE domain_id = NEW.domain_id AND type='MX';
DELETE FROM records WHERE domain_id = NEW.domain_id AND type='A' AND name=mxRecordValue;
INSERT INTO records (domain_id, name, type, content, ttl, prio) VALUES (NEW.domain_id, @domainName, 'MX', mxRecordValue, '86400', '10');
INSERT INTO records (domain_id, name, type, content, ttl) VALUE (NEW.domain_id, mxRecordValue, 'A', '85.92.140.135', '86400');
END
Cilj je da u jednom DELETE i dva INSERT query-ja koristim varijablu mxRecordValue koja bi trebalo da bude u formatu: 'mail.domen.com';
domen.com imam u @domainName, ali nikako da napravim da dobijem mail.@domainName :(
Please pomoc?! :)