Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of stored procedures, triggers,
indexes?
- 5 Answers
- 33761 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
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
What are the common mysql functions?
How to get the number of rows selected or affected by a sql statement?
Is mysql workbench a dbms?
How to Change a users password from unix shell.
How many mysql connections can handle?
Is primary key auto increment?
How to use triggers to track changes in mysql?
How can you take the backup and restore a mysql database using php?
How many sql dml commands are supported by 'mysql'?
What is difference between mongodb and mysql?
How many rows can mysql handle?
What is pdo mysql?
How to change the database engine in mysql?
How to increment dates by 1 in mysql?
