Delete selected row from table in mysql

xpda

What is the best way to delete the results of this selection from the table?

select id from taxon2 as a 
   where rank = 'No Taxon' and 
   (select count(*) from taxon2 as b 
      where a.id = b.parentid) = 0;
sgeddes

Here is a solution with an OUTER JOIN:

delete taxon2 
from taxon2
  left join taxon2 t2 on taxon2.id = t2.parentid
where t2.id is null;

And with NOT EXISTS:

delete from taxon2
where rank = 'No Taxon' 
   and not exists (
      select 1
      from (select * from taxon2) as b 
      where b.parentid=taxon2.id)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

mysql - how to select skew row from selected

From Dev

Delete selected row from datagrid view and update mysql database in C#

From Dev

MySQL delete data from a table

From Dev

Cannot delete selected a row from sqlite database

From Dev

Issue on Drawing Highcharts From Selected Row Table

From Dev

how to delete the specified row from html table and also in mysql table using php

From Dev

Delete a row from Parse Table

From Dev

AJAX Delete row in table with PHP id selected

From Dev

php/pdo/mysql accessing selected row from a select * in html table

From Dev

Mysql table replace or delete row

From Dev

delete row if checkbox is selected

From Dev

Delete an entire row from a table, using MySQL

From Dev

Delete a row from sqlite table

From Dev

iOS : Copy selected row from Table to an Array:

From Dev

Remove checkbox selected from non-selected table row

From Dev

Delete row from table conditional on a related table

From Dev

Beginner: Delete row from Table and Database PHP/HTML/MySQL

From Dev

Delete selected row from table in mysql

From Dev

MySQL delete data from a table

From Dev

Delete row from dynamic table

From Dev

php/pdo/mysql accessing selected row from a select * in html table

From Dev

Mysql table replace or delete row

From Dev

delete row if checkbox is selected

From Dev

How to delete a selected row in a html table by using jQuery?

From Dev

PHP form delete from MYSQL table dont delete the right row

From Dev

jQuery onclick delete row from mysql table

From Dev

how to delete selected row from datagridview

From Dev

MySql delete from other table

From Dev

How to delete selected row from datagridview and database?

Related Related

HotTag

Archive