CREATE TABLE test1(a1 INT);
CREATE TABLE test2(a2 INT);
CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE test4(
a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
b4 INT DEFAULT 0
);
create trigger employee_BI BEFORE INSERT
on employee
FOR EACH ROW
BEGIN
INSERT INTO employee2 values (NEW.employee_id, NEW.name, NEW.birthdate,
NEW.marriage_status, NEW.phone_number1, NEW.phone_number2, NEW.address);
END;
http://dev.mysql.com/doc/refman/5.0/en/triggers.html
Archive | sql RSS feed for this section