INSERT always places data at the "end" of the table. SQL makes no assumptions
about the ordering of data. If you specify no order, you get "arrival
sequence", being the order the data was written to the table. If you want to
see the data in a certain order, you must order it with the ORDER BY clau
What I say will not help you since this is a MySQL limitation. However, on
more fully-featured SQL systems, you can specify a referential constraint that
will delete child rows when the parent row is deleted.
You might have something like this on table C (assumes table A is the master):
create t
ture, this will work.
Loyd
On Thu, 13 Sep 2001 20:19:14 -0500, Loyd Goodbar <[EMAIL PROTECTED]>
wrote:
>On Thu, 13 Sep 2001 19:55:11 -0500, "Deryck Henson" <[EMAIL PROTECTED]>
>wrote:
>
>>OK, first of all, brilliant and well thought out. One problem, every o
