What are the advantages of stored procedures, triggers,
indexes?
Answer Posted / jeyakumar
stored procedure:
Stored procedure is a collection of sql statements.It is precompiled one so execution time is fast.Single name we can create procedure for insert,delete,update.
Triggers:
Mainly used for implementing business rules.It execute automatically when the particular event is fired. For example maximum record 100 if anybody try to insert after 100 then delete first come record(first come first out).
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do I clear a mysql database?
Explain the architecture models of SQL Server?
How would you get the current date in mysql?
How do I exit mysql?
What are the differences between char and varchar data types?
How do I update a variable in mysql?
What is mysqlcheck do?
How do you create a schema?
Can we store pdf files in mysql?
What is the phantom problem?
What is mysql sleep process?
What is relational database in mysql?
How to include comments in sql statements?
Is mysql relational database?
What are triggers mysql?