Re: delete relational data MYSQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Look up the InnoDB table type:

FOREIGN KEY ... ON DELETE CASCADE

Btw, what do you mean by "dmx"?

Ignatius
____________________________________________
----- Original Message -----
From: "tbo" <tim@copiousdg.com>
To: <php-db@lists.php.net>
Sent: Tuesday, May 20, 2003 12:33 AM
Subject:  delete relational data MYSQL


> In php and mysql and dmx, how would one modify the dmx delete record(or
> create ones own script) to delete from 2 tables containing "relationships"
> data?
>
> EXAMPLE
> a table called Books with Author ID's
> a table called Authors with ID's
>
> how could I delete all the Author's books from the Books table at the same
> time I delete that Author out of the Authors table(the Author id would be
> passed in the URL as "AID")?
>
> Any ideas or tutorials?
>
> --
> Tim Haskins
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux