MySQL triggers: passing a PK to a stored proc on the row that forced trigger?

[minestrone]

Anyone know of this can be done? I have a trigger...

CREATE TRIGGER
  db.myTrigger
AFTER UPDATE ON
  db.myTable
FOR EACH ROW CALL
   myStoredProc() ;

...but I want to pass the pk of the row being updated to the stored proc, I though it would work something like this..

CREATE TRIGGER
  db.myTrigger
AFTER UPDATE ON
  db.myTable table
FOR EACH ROW CALL
   myStoredProc( table.id ) ;

...but computer says no, trigger docs on mySql are not that great as they just introduced the functionality.

Cheers

[lilelvis2000]

CREATE TRIGGER
db.myTrigger
AFTER UPDATE ON
db.myTable table
FOR EACH ROW
begin
myStoredProc( NEW.id ) ;
end;

Does that not work?

[minestrone]

Cheers!

[lilelvis2000]

And I don't even do MySQL...I looked it up in my MySQL Cookbook!

[minestrone]

And I don't even do MySQL...I looked it up in my MySQL Cookbook!

My database skills are fairly shocking, I just seem to busk every task I have.

When I am programming in Java I know exactly what I am writing, the next 20 lines I am going to write and have a rough idea what I am going to be writing on the next hour.

Stored procs I seem to get by with "I think that might work" "**** it never worked" "how the **** do you debug this thing" "try this" repeated for 8 hours