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;

Is mysql a server?

625

---

What is meant by mysqli?

659

---

What is prepare statement in mysql?

704

---

what is database black box testing? : Mysql dba

776

---

can you tell how can you display the maximum salary in sql? : Mysql dba

636

---

Is mysql a free database?

684

---

Does mysql use tcp or udp?

677

---

Should I use pdo or mysqli?

649

---

What is row level locking?

668

---

Write a query to find duplicate rows in table?

665

---

What is MySQL?

745

---

How do I grant privileges to a user in mysql phpmyadmin?

690

---

What are the differences between a primary key and foreign key?

779

---

Write a command with which mysql table can be repaired

711

---

Do I need python for mysql?

661

---