ВУЗ:
Составители:
Рубрика:
Триггеры
4%›
œ
&&%h&" nFHiidFk•f% %'%$& ,%# "(!+
"(!! %!, "%)$"!" " %+
"&$h)!k• $!"mzAEv€""YECE€E
%!)$"',".'qXY~€E! %""$'+
)$"' %"')$4%&&% %#"$ '+
"%"'"R)$+"&4%&&% %!%!+
% !$"',%)!/ %!+
.'%%!#! "!%',!+
%)! ")!,!!!L%$!%&&%1!!,!"$+
%RL$"%L'"R %)f)%+
'6 %&&% %" D(#"#!"!ŒEpZvEh%&&%
! "!&$u %%,$!" k
"~p€Evh "$k/","%&&%!!$,R!+
!.'%#$ (h, %"!,$•
" kN%1"!#&% %%,%
&$( "(!!%&&%h %%,R$( %D!(
!$"',%)7!8%&&%, k
% &, %&&% & $( %! $"', %!"#
hˆmESk / f " D(# %" 7$!"&
%!"8/f""#!"!ŒEpZvE~p€Ev!"#"L( "+
!"((!!%&&%!,$!$h",!!"$!+
"k %
CREATE
[DEFINER = { user | CURRENT_USER }]
TRIGGER trigger_name trigger_time trigger_event
ON tbl_name FOR EACH ROW trigger_stmt
%%%$%&&%
CREATE TABLE t22 (s1 INTEGER)
CREATE TRIGGER t22_bi
BEFORE INSERT ON t22
FOR EACH ROW
BEGIN
SET @x = ‘Trigger was activated!’;
SET NEW.s1 = 55;
END;
"f& %! " %! "
mysql> INSERT INTO t22 VALUES (1)
mysql> SELECT @x, t22.* FROM t22 // вызывается триггер
+------------------------+------+
| @x | s1 |
+------------------------+------+
| Trigger was activated! | 55 |
+------------------------+------+
1 row in set (0.00 sec)
Словарь данных
-( 3!%L$%$!!%+
)1 K !R( ! ?@ABC&"(%"ArZS++
*
Страницы
- « первая
- ‹ предыдущая
- …
- 54
- 55
- 56
- 57
- 58
- …
- следующая ›
- последняя »
