List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:August 6 1999 6:23am
Subject:Re: How can i delete table1 , tabe2 simultaneously?
View as plain text  
At 15:20, 19990806, park seoung hong wrote:
>hi?
>I am park.
>i would like to delete simultaneously from table1 , tabe2.
>like as follows;
>mysql> delete from airflow, battery where uni_no =1;
>but i met a "ERROR 1064: You have an error in your SQL syntax near ' 
>battery where uni_no =1' at line 1"
>
>What can i do?

Hi, Park.  You can not do this.  You have to issue two DELETE
statements.

    DELETE FROM airflow WHERE uni_no = 1;
    DELETE FROM battery WHERE uni_no = 1;

Tim
Thread
How can i delete table1 , tabe2 simultaneously?park seoung hong6 Aug
  • Re: How can i delete table1 , tabe2 simultaneously?Thimble Smith6 Aug