Follow this topic

Last answered:

05 Oct 2022

Posted on:

04 Oct 2022

0

creating a variable fro the trigger

in SQL / MySQL Triggers

Hi, why did we need to declare a variable for the trigger creation if we are not using it?

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

05 Oct 2022

0

Hi Kfir!

Great to have you in the course and thanks for reaching out!

Could you please support your question with further explanation? Which variable are you referring to? This can help us assist you better. Thank you.

Looking forward to your answer.
Best,
Tsvetelin

Submit an answer

related questions

7

12

Resolved: M query fetch time increased after creating an index for the salaries table!

2

10

Error Code: 1418 while creating function

Mohamed Firdaus Bin Kamsani

0

6

SELECT 'CREATING DATABASE STRUCTURE' as 'INFO';

0

4

Issues in creating a new user

Lishavel Lishanthini

1

4

Error on creating a sales table

1

4

Resolved: Global variable

0

2

ERROR occured for creating table

1

2

Can someone explain when to use Before Trigger and when After Trigger????

Maxime Darbouze

0

2

Key constrain creating Item table

Maxime Darbouze

0

2

Inner Join- creating the department_dup table

0

2

why using to_date and not from_date in the last trigger example ?

0

2

Why is the data type of the variable not specified?