Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Certification Triggers

memorize.ai (lvl 286)

(0)

6 cards

()

Section 1

Preview this deck

On an insert trigger or update trigger.

Front

1 / 6

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (6)

Section 1

(6 cards)

On an insert trigger or update trigger.

Front

When can NEW.col_name be used?

Back

Examine row values to be inserted, deleted or updated. Change values inserted or updated in a table. ( check for bounds or filters ) Modify how insert update delete works. Changing data based on current circumstances.

Front

Reasons to use a Trigger

Back

On and update or Delete Trigger.

Front

When can OLD.col_name be used

Back

You cannot use the CALL statement you can't begin or end transactions. You can't create a trigger for a Temporary table or a view. Trigger is subject to the same binary log-related function as stored procs.

Front

What are the limitations of MySQL triggers

Back

CREATE TRIGGER trigger_name { BEFORE | AFTER } { INSERT | UPDATE | DELETE } ON table_name FOR EACH ROW triggered_statement

Front

What is the syntax for create trigger?

Back

TRIGGER privilege

Front

What privilege do you need to create drop, execute or display triggers

Back