Interested to Buy Any Domain ? << Click Here >> for more details...
How to create triggers in MySQL?
- 1 Answers
- 1672 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 |
What is the default port for mysql and how it can change?
What do we use to remove duplicate records while fetching a data in mysql ?
What is a csv table?
How many tables will create when we create table, what are they?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
Can we store pdf files in mysql?
Tell us something about heap tables?
How to determine the location of the data directory?
What are the 5 r's of managing behaviors?
Is oracle mysql free?
what is the main difference between myisam and innodb
What is a trigger in mysql?
-
Oracle (3253) - 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)
