Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of stored procedures, triggers,
indexes?
- 5 Answers
- 33563 Views
- I also Faced
- E-Mail Answers
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
What is difference mysql and mysqli?
How do I edit a trigger in mysql?
How do you insert a table?
What are the 'mysql' command line options?
How do you create a new database in mysql?
What is table level locking in mysql?
Explain the difference between primary key and candidate key in mysql?
what is cte? : Mysql dba
How to use 'mysql' to run sql statements?
How do I stop a mysql service?
Is mysql same as mariadb?
How to delete a column and add a new column to database
How do I tune a mysql query?
What is mysqli procedural?
What are the functions of mysql?
