Dear all,

I have several tables with foreign key constraints.

What I want to achieve is if a record is referred by any other tables,
the record should not be allowed further modification and a copied
record should be inserted for update instead.

So I want to ask whether there exists a function to do this in Java or
PHP, or normally how should one do this?

Thanks!

On Mon, 4 Oct 2010 01:12:10 -0700 (PDT), cell wrote:
You'll have to write your own.

All the information about that is in the INFORMATON_SCHEMA though, and
the TABLE_CONSTRAINTS table will be where to start looking.

--
100. Finally, to keep my subjects permanently locked in a mindless
trance, I will provide each of them with free unlimited Internet
access.
--Peter Anspach's list of things to do as an Evil Overlord