Возможно ли это сделать в Mysql?

    CREATE TRIGGER trigger_name trigger_time trigger_event
    ON tbl_name FOR EACH ROW trigger_stmt* This source code was highlighted with Source Code Highlighter.

    — таблица, за которой мы будем следить
    CREATE TABLE `test` (
    `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `content` TEXT NOT NULL
    ) ENGINE = MYISAM
    — лог
    CREATE TABLE `log` (
    `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `msg` VARCHAR( 255 ) NOT NULL,
    `time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `row_id` INT( 11 ) NOT NULL
    ) ENGINE = MYISAM
    — триггер
    DELIMITER |
    CREATE TRIGGER `update_test` AFTER INSERT ON `test`
    FOR EACH ROW BEGIN
       INSERT INTO log Set msg = 'insert', row_id = NEW.id;
    END;* This source code was highlighted with Source Code Highlighter.

    — Удаляем триггер
    DROP TRIGGER `update_test`;
    — Cоздадим еще одну таблицу,
    — в которой будут храниться резервные копии строк из таблицы test
    CREATE TABLE `testing`.`backup` (
    `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `row_id` INT( 11 ) UNSIGNED NOT NULL,
    `content` TEXT NOT NULL
    ) ENGINE = MYISAM
    — триггеры
    DELIMITER |
    CREATE TRIGGER `update_test` before update ON `test`
    FOR EACH ROW BEGIN
      INSERT INTO backup Set row_id = OLD.id, content = OLD.content;
    END;
 
    CREATE TRIGGER `delete_test` before delete ON `test`
    FOR EACH ROW BEGIN
      INSERT INTO backup Set row_id = OLD.id, content = OLD.content;
    END* This source code was highlighted with Source Code Highlighter.