Re: Mysql Trigger

2011-07-10 Thread Peter Brawley
On 7/10/2011 3:32 AM, vishesh kumar wrote: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.

Re: Mysql Trigger

2011-07-10 Thread vishesh kumar
Thanks for reply , but i want to do only for certain record that i will put using IF On Sun, Jul 10, 2011 at 2:42 PM, Reindl Harald wrote: > > > Am 10.07.2011 10:32, schrieb vishesh kumar: > > Hi Members > > > > Whats wrong i am doing in following create trigger statement > > > > Create trigger

Re: Mysql Trigger

2011-07-10 Thread Reindl Harald
Am 10.07.2011 10:32, schrieb 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