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;

Can I install mysql on mac?

1029

---

Why should I use mysql?

997

---

Is oracle better than mysql?

940

---

Is microsoft sql same as mysql?

1032

---

How do I run mysql without installing?

1023

---

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

995

---

What does do in mysql?

942

---

Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

1004

---

how to connect a php script with the mysql database?

1119

---

How do I select a table in mysql?

980

---

How do I delete a table in mysql workbench?

1084

---

Can we rename database in mysql?

1000

---

Are stored procedures precompiled?

1031

---

How do you say mysql?

959

---

Explain the difference between delete and truncate.

1039

---