List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:April 3 1999 2:07am
Subject:Re: Deleting from tables
View as plain text  
No, you can't do it in one SQL statement.

Tim


On Fri, Apr 02, 1999 at 06:04:10PM -0800, Darin Isola wrote:
> Hi all,
> 
> How would i go about deleting data from 6 different tables, at once?
> 
> I've tried 
> 
> delete from departments,
> delete from enddate,
> delete from job_code_desired,
> delete from job_code_primary,
> delete from job_code_required,
> delete from job_code_secondary,
> delete from main;
> 
> with no luck and:
> 
> delete from departments,
> enddate,
> job_code_desired,
> job_code_primary,
> job_code_required,
> job_code_secondary,
> main;
> 
> with still no luck.
> 
> Is it possible?
> 
> TIA,
> 
> Darin;
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread1358@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 
Thread
I Lost My Password.wertyu3 Apr
  • Re: I Lost My Password.Thimble Smith3 Apr
    • Deleting from tablesDarin Isola3 Apr
      • Re: Deleting from tablesThimble Smith3 Apr