Answer Posted / kalai

1.Advsntsge of Stored Procedures:
================================
Stored Procedures are precompiled one.
it is the group of sql statements.
stored procedure like a application programming.
stored procedure is a fast one because it is already
precompiled.
stored procedure is the one is easy to maintain.

2.Advantage of Triggers:
========================
Triggers is a special kind of procedure.
the Main advantage of the trigger is automatic.
whenever the table affected by insert update or delete
query that time the triggers will implicitely call.

3.Advantage of Indexs:
======================
The Main advantage of the indexes is speed.
if the table having the indexes while selecting or
filtering the row(s) 0r columns(s) ,the execution time
very fast.
but, if you use the indexed table the insert update and
delete will be slow.

How we can get the current date in mysql?

946

---

What is a longblob?

928

---

What are the drivers in MySQL?

1434

---

Is number a datatype in mysql?

925

---

What is default schema in mysql?

916

---

What is mysql community edition?

925

---

Write a query to create a database and a table?

874

---

How to show all tables with 'mysql'?

985

---

using primary can we relate two table, with out foreign key?

2686

---

Where’s database data actually stored? Is there a way to see the files which are stored?

960

---

How many queries can mysql handle?

954

---

In which year mysql created?

949

---

What is required to create mysql database?

967

---

Can mongodb replace mysql?

916

---

What is database engine in mysql?

923

---