Prikazi cijelu temu 30.06.2015 17:47
Gjoreski Van mreze
Administrator
Registrovan od:02.02.2009
Lokacija:Ohrid Makedonija


Predmet:Re: Trigerri na My Sql
Moze malku pomos

Imam na mssql baza eden vakov triger
PreuzmiIzvorni kôd (SQL):
  1. SET ANSI_NULLS ON
  2. SET QUOTED_IDENTIFIER ON
  3. GO
  4. ALTER TRIGGER [dbo].[T_tblSmetki_Stavki_ITrig] ON [dbo].[tblSmetki_Stavki] FOR INSERT AS
  5. SET NOCOUNT ON
  6. /* * PREVENT INSERTS IF NO MATCHING KEY IN 'tblArtikli' */
  7. IF (SELECT COUNT(*) FROM inserted) !=
  8.    (SELECT COUNT(*) FROM tblArtikli, inserted WHERE (tblArtikli.ID_Artikal = inserted.ssStavka))
  9.     BEGIN
  10.         RAISERROR 44447 'The record can''t be added or changed. Referential integrity rules require a related record in table ''tblArtikli''.'
  11.         ROLLBACK TRANSACTION
  12.     END
  13.  
  14. /* * PREVENT INSERTS IF NO MATCHING KEY IN 'tblSmetki' */
  15. IF (SELECT COUNT(*) FROM inserted) !=
  16.    (SELECT COUNT(*) FROM tblSmetki, inserted WHERE (tblSmetki.ID_Smetka = inserted.ssSmetka))
  17.     BEGIN
  18.         RAISERROR 44447 'The record can''t be added or changed. Referential integrity rules require a related record in table ''tblSmetki''.'
  19.         ROLLBACK TRANSACTION
  20.     END

Kako ovaj isti triger da go napravam za mySql