stored procedure: Stored procedure is a collection of sql statements.

What are the advantages of stored procedures, triggers,
indexes?

Question Posted / jeyakumar

5 Answers
33480 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

Please Help Members By Posting Answers For Below Questions

How can I connect mysql database?

878

How do I edit a stored procedure in mysql?

893

What is the use of concat() in mysql?

973

What is view in mysql?

958

What is datatype in mysql?

918

What is deterministic in mysql?

962

What is mysql architecture?

997

How to find second highest salary from a table?

1002

How do I find mysql version in mysql workbench?

917

Is mysql running ubuntu?

960

What is mysql data directory? How to determine the location of the data directory?

919

Is mysql connect deprecated?

943

How can I create table in mysql?

1001

What is memory table?

882

What is select query in mysql?

893