Interested to Buy Any Domain ? << Click Here >> for more details...
How to create triggers in MySQL?
- 1 Answers
- 1602 Views
- I also Faced
- E-Mail Answers
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 This Answer Correct ? | 0 Yes | 0 No |
How to get a list of indexes of an existing table?
What is relational database in mysql?
What is regexp?
What are the purposes of using enum and set data types?
How can I create table in mysql?
What are the differences between mysql vs sql server?
What is query log in mysql?
about foregine
What are the advantages of MySQL when compared with Oracle?
What is difference between unix timestamp and mysql timestamp?
What are the drivers in MySQL?
What is truncate in mysql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
