Hi,
I've created a Trigger and want to edit it. Using MySQL Workbench, I can
Alter the table, and click Triggers and select the trigger action I want to
edit (on my local database, MySQL running on same PC)
However, if I try the exact same procedure on a Trigger on a remote
database, I don't see
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
mysql ver 5.0.26 standard
Can a trigger call a procedure that returns a result
set?
I am trying to get around this error msg.
ERROR 1415 (0A000): Not allowed to return a result set
from a trigger
Thanks
-winn
Below is a more concise description of my issue and
logic pattern
when a record is
Ferindo Middleton Jr wrote:
Gleb Paharenko wrote:
Hello.
It seems that you forgot to OPEN the cursor. The trigger should be
similar to this one:
CREATE TRIGGER trigger_registration_and_attendance_before_insert
BEFORE INSERT
ON registration_and_attendance
FOR EACH ROW
BEGIN
DECLARE schedule_c