Predmet:Re: Trigerri na My Sql
Moze malku pomos
Imam na mssql baza eden vakov triger
PreuzmiIzvorni kôd (SQL):SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[T_tblSmetki_Stavki_ITrig] ON [dbo].[tblSmetki_Stavki] FOR INSERT AS
SET NOCOUNT ON
/* * PREVENT INSERTS IF NO MATCHING KEY IN 'tblArtikli' */
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM tblArtikli, inserted WHERE (tblArtikli.ID_Artikal = inserted.ssStavka))
BEGIN
RAISERROR 44447 'The record can''t be added or changed. Referential integrity rules require a related record in table ''tblArtikli''.'
ROLLBACK TRANSACTION
END
/* * PREVENT INSERTS IF NO MATCHING KEY IN 'tblSmetki' */
IF (SELECT COUNT(*) FROM inserted) !=
(SELECT COUNT(*) FROM tblSmetki, inserted WHERE (tblSmetki.ID_Smetka = inserted.ssSmetka))
BEGIN
RAISERROR 44447 'The record can''t be added or changed. Referential integrity rules require a related record in table ''tblSmetki''.'
ROLLBACK TRANSACTION
END
Kako ovaj isti triger da go napravam za mySql