The above trigger will give error of mutating table as in this trigger yo

how to create a primary key with out creating an index?

Question Posted / anubha

Answer Posted / anubha

The above trigger will give error of mutating table as in
this trigger you are doing dml operation on the triggering
table.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between instead of trigger and after trigger?

1067

What is transaction control language (tcl)?

1186

What is an inconsistent dependency?

1087

how to check myisam tables for errors? : Sql dba

1395

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1061

List the ways to get the count of records in a table?

942

what is the stuff function and how does it differ from the replace function? : Sql dba

1108

how to start mysql server? : Sql dba

1239

What is the purpose of using pl/sql?

1189

Is sql an operating system?

1075

Is it possible to create startup or shutdown trigger for on-schema?

1092

What is sql character function?

1151

Why schema is used in sql?

1089

Explain the components of sql?

1108

what are all the different types of indexes? : Sql dba

1104