Top "Sql-delete" questions

The SQL DELETE statement allows you to delete a single row or multiple rows from a SQL table.

In SQL, is UPDATE always faster than DELETE+INSERT?

Say I have a simple table that has the following fields: ID: int, autoincremental (identity), primary key Name: varchar(50), unique, …

sql sql-insert sql-delete
How do I delete multiple rows with different IDs?

I want to do something like this: DELETE FROM table WHERE id IN (SELECT ....) How can I do that?

sql sql-delete
Delete all rows with timestamp older than x days

I want to delete all the rows with timestamp older than 180 days from a specific table in my database. I've …

mysql sql-delete
How to delete/create databases in Neo4j?

Is it possible to create/delete different databases in the graph database Neo4j like in MySQL? Or, at least, …

database neo4j nodes sql-delete relationships
How to delete duplicate entries?

I have to add a unique constraint to an existing table. This is fine except that the table has millions …

sql postgresql duplicate-removal unique-constraint sql-delete
java.lang.IllegalArgumentException: Removing a detached instance com.test.User#5

I have a java EE project using JPA (transaction-type="JTA"), hibernate as provider. I write my beans to handle the …

jpa sql-delete entitymanager illegalargumentexception
Google BigQuery Delete Rows?

Anyone know of any plans to add support for delete parts of data from a table in Google Bigquery? The …

google-bigquery sql-delete delete-row
Deleting millions of rows in MySQL

I recently found and fixed a bug in a site I was working on that resulted in millions of duplicate …

mysql query-performance maintenance sql-delete
How to delete in MS Access when using JOIN's?

I am attempting to use the DELETE clause in MS Access and have an issue when also using the JOIN …

sql ms-access delete-row sql-delete
How to Delete All Items From SQLite in Android

I would like to make an app where the user clicks a button, and the SQLite database is cleared. Here's …

android sqlite sql-delete