Advertisement
Guest User

Untitled

a guest
Dec 12th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.16 KB | None | 0 0
  1. DELIMITER //
  2. DELIMITER //
  3. CREATE TRIGGER 'updateperson'
  4. BEFORE INSERT on person
  5. FOR EACH ROW
  6. BEGIN
  7. BEGIN
  8.     SET NEW.doctor_ID = 1;
  9.  
  10. end //
  11.  DELIMITER;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement