-
how to write a trigger when I call this store procedure
CREATE PROCEDURE dropStudent()
BEGIN
delete from PostDeferment where (Date(Current_Date)-Date(AccessTime))>=8;
END
I want select the UniversityN , and accessTime on PostDeferment and insert into my log table
thank you!
________
YAMAHA DRUMS
Last edited by sql; 03-06-2011 at 02:08 AM.
-
insert into log select UniversityN, accessTime, PostDeferment from ... where ...
-
get it , Thank you!
________
CANNABIS NEWS
Last edited by sql; 03-06-2011 at 02:09 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|