Re: Delete data from more than one table

[Jeff Mathis]

if your schema can be set up to use pk/fk constraints, you can add an on 
delete cascade statement.

if not, then its maybe safer to delete table by table anyway.

Jerry Swanson wrote:
I can delete data for one table with no problem:
delete from table;
I need to delete data for more than one table.
I tried to run this query: 

delete from account, survey;
//But the query crashes.
 
Any ideas how to delete data for more than one query.
TH


--
Jeff Mathis, Ph.D.                      505-955-1434
Prediction Company                      [EMAIL PROTECTED]
525 Camino de los Marquez, Ste 6        http://www.predict.com
Santa Fe, NM 87505
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]