Answer Posted / saraswathi muthuraman
IF you have a trigger on table emp_test. Inside that
trigger, your are trying to update/insert in the same table
emp_test.
Then mutating table error will occur.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what is a trigger in mysql? Define different types of trigger. : Sql dba
tell us something about heap tables. : Sql dba
what is query cache in mysql? : Sql dba
What is the difference between partitioning and sharding?
Explain ttitle and btitle.
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How insert into statements in sql?
What is the main reason behind using an index?
What is where clause in sql?
What is a heap in sql?
What is indexing in sql and its types?
What is cost in sql execution plan?
What is a common use of group by in sql?
What are sql constraints?
What is linq to sql?