Answer Posted / ankit joshi

Advantages of Triggers

Triggers are basically the statements that are executed
automatically after any of the DML operation.
Its basic advantage is that we dont need to invoke it again
and again it will be created once and serve us for the rest
of time.
Triggers are not invoked from the Application end rather it
will be invoked from the Database Management System.
Triggers are used to simply make a look on any of the
activity going on the client side.



Advantages of Stored Procedured:

Stored procedured are the precompiled statements and one of
its biggest advantage is that it speed up the performance
of our application.

How to concatenate two character strings?

1009

---

Is blocked because of many connection errors mysql?

822

---

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

992

---

How to dump a table to a file with 'mysqldump'?

1008

---

How many rows can mysql hold?

870

---

What is the default port for mysql and how it can change?

1039

---

Which storage engine is best in mysql?

927

---

How to convert character strings to dates?

1061

---

What is mysql in linux?

1003

---

can you tell the order of sql select statement? : Mysql dba

890

---

What are the difference between mongodb and mysql?

1314

---

What are the differences between innodb and myisam engines?

961

---

What are procedures in mysql?

926

---

how to display nth highest salary from a table in a mysql query? : Mysql dba

1049

---

How do I select a database in mysql?

1041

---