Interested to Buy Any Domain ? << Click Here >> for more details...
can anyone explain about stored procedure,Triggers and
transaction in php?
- 2 Answers
- 6214 Views
- I also Faced
- E-Mail Answers
Answer Posted / jit
A stored procedure is simply a procedure that is stored on
the database server. MySQL developers have to date
unthinkingly written and stored their procedures on the
application (or web) server, mainly because there hasn't
been an option. That has been limiting. Some have claimed
that there are two schools of thought - one claiming that
logic should be in the application, the other saying it
should reside in the database. However, most professionals
would not bind themselves to one or other viewpoint at all
times. As always, there are times when doing either makes
sense. Unfortunately, some of the staunchest adherents of
the in the application school are only there because until
now they have had no choice, and it is what they are used to
doing.
Triggers are programmable events that react to queries and
reside directly on the database server. Triggers can be
executed before or after INSERT, UPDATE or DELETE
statements.There are several reasons to use triggers.
Triggers can automate a lot of stuff that you may have been
doing by hand before. The main reason I use triggers is to
maintain the integrity of one table that might rely on
another table. For example, if TableA references TableB and
a value from TableB gets deleted, you could have a trigger
setup to handle the data in TableA. Perhaps the data in
TableA should be reset to a generic value or maybe the data
should just be deleted completely.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Which variable declarations within a class is invalid in php?
Hi this is amul jani here, i complied my graduation in B.com stream.. but as career i looking for PHP language.. to get shape my career. so is that possible to enter in IT world.. for me how much scope of develop my career in this field.. amul jani
What is compact function php?
Is php faster than nodejs?
Tell me what does $_env means?
Explain the purpose of output buffering in php.
How to select a database in php?
What is str_replace()?
Why php is sometimes called as embedded scripting language?
What is difference between session and cookies in php?
List some array functions in php?
Is array a key php?
Is php difficult to learn?
write a prog using insert,update,delete in this manner as output? name: phno. add button 1.name phno. edit button delete button 2.
How do I expire a php session after 30 minutes?
