Archive | sql RSS feed for this section

Create Trigger on mysql

22 May
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
Follow

Get every new post delivered to your Inbox.