Re: update other row in same table

[William Chiquito]

Hi Christian,

Maybe a trigger as following you it can be useful:

DELIMITER $$

DROP TRIGGER `bustatuses`$$

CREATE TRIGGER `bustatuses` BEFORE UPDATE ON `statuses`
FOR EACH ROW
BEGIN
SET NEW.stop = OLD.start;
END$$

DELIMITER ;

UPDATE `statuses` SET `start` = NOW() WHERE `id` = [oldId];