Interested to Buy Any Domain ? << Click Here >> for more details...
How to create triggers in MySQL?
- 1 Answers
- 1486 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 |
Is mysql a good database?
How do you rename a table?
What do you mean by % and _ in the LIKE statement?
What is memory table?
Is sqlite faster than mysql?
in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.
Is mysql query case sensitive?
Is mysql a database?
What is prepared statement in mysql?
Explain the difference between BOOL, TINYINT and BIT?
What is row level locking in access?
What is indexing 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)
