What is mutating table?

Answer Posted / gopal

Mutatation of table is a state of table when in
before /after update trigger table tries to update the same
table.As the call of update also calls same trigger then
the trigger will be called infinite times. then the table
will be mutating

Is This Answer Correct ?    43 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql partition?

541


What is an inner join sql?

538


How do I remove duplicates in two columns?

500


What is a sql statement?

521


Does group by remove duplicates?

538






Is postgresql a nosql database?

521


What is a record in a database?

552


How to run pl sql program in mysql?

505


What is rank dense_rank and partition in sql?

529


How can I delete duplicate rows?

554


What is query execution plan in sql?

556


what is 'mysqld'? : Sql dba

533


Which function is used to return remainder in a division operator in sql?

573


How do I count rows in sql query?

482


How exception is different from error?

533