Mysql Trigger

[vishesh kumar]

Hi Members

Whats wrong i am doing in following create trigger statement

  Create trigger test before insert on user
   for each row
   begin
      set New.host=upper(new.host)
   end

Above statement giving error check sql syntax , please  guide me. I want to
put host field value in uppercase in user table
-- 
http://linuxmantra.com