Help for this page

Select Code to Download


  1. or download this
    CREATE TRIGGER bar AFTER INSERT ON foo
    FOR EACH ROW BEGIN
    ...
      SET @a = x; -- set user variable outside trigger
    
    END//
    
  2. or download this
    
    SET @a = 0;
    
    SELECT @a;