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 , please guide me. I want to > put host field value in uppercase in user table
a) why "before insert" b) why "for each row" when a single update can do this c) update table_name set fieldname=upper(fieldname)
signature.asc
Description: OpenPGP digital signature
