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;

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3972

---

What are the objects can be created using CREATE statement?

990

---

How do I tune a mysql query?

891

---

How do I view tables in mysql workbench?

918

---

Can a table have multiple primary keys?

902

---

Why do we use the mysql database server?

1050

---

What are string data types?

1030

---

Is Mysql query is case sensitive?

1023

---

What is save point in mysql?

959

---

Define REGEXP?

1105

---

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

1001

---

How to do login in mysql with unix shell.

1109

---

How you will show all data from a table.

989

---

What is the innodb in mysql?

1044

---

Is mysql distributed?

929

---