[SQL] pobierz, plaintext 
CREATE TRIGGER log_pub_ip_update
BEFORE UPDATE ON nodes
    FOR EACH ROW
    BEGIN
        IF OLD.ipaddr_pub != NEW.ipaddr_pub
        THEN
        END IF;
     END;
[SQL] pobierz, plaintext 

MySQL zwrócił komunikat:
#1064 - Something is wrong in your syntax obok 'END IF' w linii 7

gdzie tutaj jest blad?

Po THEN brakuje komendy jaka ma byc wykononana. No chyba po to dales tego IF,zeby cos zrobic

[SQL] pobierz, plaintext 
CREATE TRIGGER log_pub_ip_update
BEFORE UPDATE ON nodes
    FOR EACH ROW
    BEGIN
        IF OLD.ipaddr_pub != NEW.ipaddr_pub
        THEN
                INSERT INTO log_ip_change
                    (
                        ipaddr_pub,
                        ipaddr_pub_new,
                        moddate,
                        ownerid       
                    )
                    VALUES
                    (
                        OLD.ipaddr_pub,
                        NEW.ipaddr_pub,                        
                        OLD.moddate,
                        OLD.ownerid
                    );
        END IF;
     END;
[SQL] pobierz, plaintext 

MySQL zwrócił komunikat:
#1064 - Something is wrong in your syntax obok '' w linii 20

z komenda czy bez nadal ten sam blad

[SQL] pobierz, plaintext 
DELIMITER |
 
CREATE TRIGGER log_pub_ip_update
BEFORE UPDATE ON nodes
    FOR EACH ROW
    BEGIN
        IF OLD.ipaddr_pub != NEW.ipaddr_pub
        THEN
                INSERT INTO log_ip_change
                    (
                        ipaddr_pub,
                        ipaddr_pub_new,
                        moddate,
                        ownerid       
                    )
                    VALUES
                    (
                        OLD.ipaddr_pub,
                        NEW.ipaddr_pub,                        
                        OLD.moddate,
                        OLD.ownerid
                    );
        END IF;
     END|
DELIMITER ;
[SQL] pobierz, plaintext 

Dzieki dziala