SQL - Procedure and Trigger
About the Lecture
The lecture SQL - Procedure and Trigger by Martin Holzke is from the course SQL Database for Beginners. It contains the following chapters:
- Introduction - About Procedure Basics
- the Stall Procedure
- About Triggers
- Trigger Creation
Author of lecture SQL - Procedure and Trigger
Martin Holzke
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
Excerpts from the accompanying material
... to the table comments and verify that the trigger is working correctly. Answer: Insert into comments(notes) values (‘inserting a new note’) Post-test with: Select * from comments This should show the new record including primary key and timestamp. 6) Write a query adding a trigger to the table comments ...
... end; @@ delimiter; Note: This is a very basic solution lacking any error handling, etc. 10) Write queries adding a new project “SEO” with a budget of 400 using the above stored procedure and verify that the stored procedure works correctly. Answer: Call addproject(‘SEO’, 400); Post-test with: select * from project ...
