Skip to main content
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
Source Link

This technique is possible. Here is the correct syntax:

DELETE A.*,B.* FROM
member A INNER JOIN subscriptions B USING (type_id)
WHERE A.type_id = 1;

I have another post from June 26, 2013 on this same DELETE syntax on multiple tables : Deleting Data From Multiple Tables

As for the original question, @Michael-sqlbot has it right. The particular tool you are using does not support executing multiple queries. At the very least, it is not configured to run multiple queries.

This technique is possible. Here is the correct syntax:

DELETE A.*,B.* FROM
member A INNER JOIN subscriptions B USING (type_id)
WHERE A.type_id = 1;

I have another post from June 26, 2013 on this same DELETE syntax on multiple tables : Deleting Data From Multiple Tables

As for the original question, @Michael-sqlbot has it right. The particular tool you are using does not support executing multiple queries. At the very least, it is not configured to run multiple queries.

added 265 characters in body
Source Link
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

This technique is possible. Here is the correct syntax:

DELETE A.*,B.* FROM
member A INNER JOIN subscriptions B USING (type_id)
WHERE A.type_id = 1;

I have another post from June 26, 2013 on this same DELETE syntax on multiple tables : Deleting Data From Multiple Tables

As for the original question, @Michael-sqlbot has it right. The particular tool you are using does not support executing multiple queries. At the very least, it is not configured to run multiple queries.

This technique is possible. Here is the correct syntax:

DELETE A.*,B.* FROM
member A INNER JOIN subscriptions B USING (type_id)
WHERE A.type_id = 1;

I have another post from June 26, 2013 on this same DELETE syntax on multiple tables : Deleting Data From Multiple Tables

This technique is possible. Here is the correct syntax:

DELETE A.*,B.* FROM
member A INNER JOIN subscriptions B USING (type_id)
WHERE A.type_id = 1;

I have another post from June 26, 2013 on this same DELETE syntax on multiple tables : Deleting Data From Multiple Tables

As for the original question, @Michael-sqlbot has it right. The particular tool you are using does not support executing multiple queries. At the very least, it is not configured to run multiple queries.

Source Link
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

This technique is possible. Here is the correct syntax:

DELETE A.*,B.* FROM
member A INNER JOIN subscriptions B USING (type_id)
WHERE A.type_id = 1;

I have another post from June 26, 2013 on this same DELETE syntax on multiple tables : Deleting Data From Multiple Tables