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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of triggers?

545


Why stored procedure is faster than query?

521


How to select random rows from a table?

529


Why we use cross join?

543


how to do backup entire database? : Transact sql

620






What is the purpose of primary key?

535


What are sql indexes?

549


What are crud methods?

553


What is the use of double ampersand (&&) in sql queries? Give an example

613


what is an index? : Sql dba

529


How do I find duplicates in sql?

511


how to drop an existing index in mysql? : Sql dba

543


What is the difference between subquery and correlated query?

534


how to write date and time literals? : Sql dba

536


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

561