Top "Sql-delete" questions

Deleting rows from SQLite table when no match exists in another table

I need to delete rows from an SQLite table where their row IDs do not exist in another table. The …

sqlite left-join sql-delete

MySQL delete row from multiple tables

Is this the correct way to do it? DELETE t1, t2, t3, t4 FROM table1 as t1 INNER JOIN table2 …

mysql sql delete-row sql-delete

INSERT deleted values into a table before DELETE with a DELETE TRIGGER

For some reason I can't find the exact answer that I need. I searched for at last 20 minutes in here. …

sql sql-server tsql triggers sql-delete

MySQL insert on duplicate key; delete?

Is there a way of removing record on duplicate key in MySQL? Say we have a record in the database …

mysql key duplicate-removal sql-delete

How to delete multiple rows with 2 columns as composite primary key in MySQL?

My innodb table has the following structure: 4 columns (CountryID, Year, %Change, Source), with the 2 columns (CountryID, Year) as the primary …

mysql sql-delete composite-primary-key multiple-records

how can I delete duplicates in SQLite?

I have a SQLite DB where the statement: SELECT messdatum, count(*) as anzahl from lipo GROUP BY Messdatum ORDER BY …

sqlite sql-delete

How do you enable LIMIT for DELETE in SQLite?

Using PHP, I have a simple database that may store multiple items with the same content. I want to delete …

sqlite limit sql-delete

REPLACE INTO, does it re-use the PRIMARY KEY?

The REPLACE INTO function in MySQL works in such a way that it deletes and inserts the row. In my …

mysql sql duplicates sql-insert sql-delete

Trying to delete when not exists is not working. Multiple columns in primary key

I am currently trying to delete from Table A where a corresponding record is not being used in Table B. …

sql sql-delete exists not-exists

How to write a trigger to abort delete in MYSQL?

I read this article but it seems not work for delete. I got this error when tried to create a …

mysql triggers sql-delete