Answer Posted / hrindows@gmail.com

We can use the CREATE TRIGGER statement for creating a new trigger in MySQL.

SYNTAX:
CREATE TRIGGER trigger_name
(AFTER | BEFORE) (INSERT | UPDATE | DELETE)
ON table_name FOR EACH ROW
BEGIN
--variable declarations
--trigger code
END;

Explain the difference between primary key and candidate key in mysql?

1007

---

Can you tell few best practices to be followed for optimization in sql?

971

---

What is the storage engine for mysql?

1004

---

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

2761

---

What is innodb_buffer_pool_size?

1028

---

What is ISAM?

1158

---

How do I connect to mysql database?

1086

---

What is mysql enterprise edition?

956

---

How can we get total number of records by query in mysql?

956

---

How do you rename a procedure in mysql?

985

---

What is save point in mysql?

1001

---

How can you handle the –secure-file-priv in mysql?

989

---

How can we change the data type of a column of a table?

1047

---

What is the latest version of php and mysql?

1267

---

what is constraints? Also explain the different types of constraints?

1020

---