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



multi-table delete start with MySQL 4.0, take a look here, it can be useful :
http://dev.mysql.com/doc/mysql/en/DELETE.html


--
Philippe Poelvoorde
COS Trading Ltd.


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to