LATIHAN FLUTTER WEEK#5 : SIKAR MEMBUAT TRIGGER MYSQL

LATIHAN FLUTTER WEEK#5 : SIKAR MEMBUAT TRIGGER MYSQL

trigger : addUser

INSERT INTO user(
    userNik, userName, userPass, userLevel, userStatus
)VALUES(      
    OLD.karNik,
    OLD.karNik,
    md5('12345678'),
    '0'
);

trigger : updateStatusUser

UPDATE user SET userStatus = '0' WHERE NEW.karStatus = 'O'

Flutter Developer