a guest Dec 19th, 2018 57 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. BEGIN
  2.     IF (NEW.UserType = 'Client') THEN
  3.         INSERT INTO Client SET Username = NEW.Username ;
  4.     ELSEIF (NEW.UserType = 'Courier') THEN
  5.         INSERT INTO Courier SET Username = NEW.Username ;
  6.     ELSEIF (NEW.UserType = 'Storeman') THEN
  7.         INSERT INTO Storeman SET Username = NEW.Username ;
  8. END IF;
  9. END
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand