Dear all,
Today I need to create a schema for my application website that allows
user comments too.
I think we have to maintain hierarchical data and it is very common as
all sites are supporting this feature.
Can somebody suggest me some guidelines to follow and some links too.
Thanks
-
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.
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
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
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