Mysql + trigger+provlima stin insert

[nojipa]

Signomi pou grafo me latinikous xaraktires ala vriskome sto exoteriko!

 

To provlima mou ine :Oti se mia vasi me mysql exo dio pinakes ton host (hostid, hostname) kai ton hostdb(hostid,hostname). kai thelo otan ginete mia isagogi ston host meso trigger na ginete kai ston hostdb. O kodikas pou exo grapsi gia ton trigger ine .

 

CREATE TRIGGER hostid_ins

AFTER INSERT ON host

FOR EACH ROW

BEGIN

INSERT INTO hostdb(hostid,hostname) VALUES (NEW.hostid,NEW.hostname)

END;

 

kai mia paralagi pou exo grapsi ine

 

CREATE TRIGGER hostid_ins

AFTER INSERT ON host

FOR EACH ROW

BEGIN

INSERT INTO hostdb SET hostid=NEW.hostid;

INSERT INTO hostdb SET hostname=NEW.hostname;

END;

 

Mou bgazi oti exo lathos stis insert

Sas euxaristo poli!!!

[nojipa]

Pedia to vrika !!! Aplos den theli oi dio pinakes ta pedia na exoun idio onoma!!

SAS Euxaristo!!