Answer / 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;

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

0 Answers  

---

Explain the architecture models of SQL Server?

0 Answers  

---

What are the ways in which you can retrieve data in the result set of mysql using php?

0 Answers  

---

What does myisamchk do?

1 Answers  

---

How to delete the repeated records from a table?

0 Answers  

---

Describe mysql transaction properties.

0 Answers  

---

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

0 Answers  

---

What are the non-standard sql commands supported by 'mysql'?

0 Answers  

---

Differentiate between FLOAT and DOUBLE?

1 Answers  

---

How do I enable mysqli extension?

0 Answers  

---

What is full text indexing in mysql?

0 Answers  

---

What are the functions of commit and rollback statements?

0 Answers  

---