DROP TRIGGER IF EXIST `caps_BUPD`;
DELIMITER $$
CREATE TRIGGER `caps_BUPD` BEFORE UPDATE ON `caps`
здесь тело триггера
$$
DELIMITER ;FOR EACH ROW BEGIN
IF NEW.`rate` != OLD.`rate` THEN
SET NEW.`time_change` = NOW();
END IF;
ENDdst = ((dst << 12) | dst) & 0xF000F;
dst = ((dst << 6) | dst) & 0x3030303;
dst = (dst << 3) | dst) & 0x11111111;<?php
$A = array(array('id' => 1, 'name' => 'test1'),
array('id' => 2, 'name' => 'test2'),
array('id' => 3, 'name' => 'test3'));
$B = array(array('id' => 1, 'value' => 10),
array('id' => 3, 'value' => 30),
array('id' => 4, 'value' => 40));
$A = array_udiff($A, $B, function($a, $b) { return $a['id'] - $b['id']; });
print_r($A);
?>Array (
[1] => Array (
[id] => 2
[name] => test2
)
)