Alex Rivera | Logout

Questions tagged sql-delete

23 questions

Sort by: Newest Votes Active
124
votes
6
answers

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

sql select where-clause advantage-database-server sql-delete
asked 2013-07-09T12:56:30.283
9
votes
2
answers

SQL - return deleted rows

sql select sql-delete
asked 2013-05-21T12:11:48.597
13
votes
3
answers

"The total number of locks exceeds the lock table size" Deleting 267 Records

mysql locking innodb sql-delete
asked 2012-04-20T20:59:56.007
11
votes
3
answers

MySQL DELETE all but latest X records

mysql sql-delete records
asked 2012-01-16T20:44:40.410
11
votes
3
answers

Sql Server Delete and Merge performance

sql-server t-sql merge sql-delete
asked 2011-10-02T13:48:02.967
15
votes
5
answers

Very slow delete on mysql base with subquery

mysql subquery config sql-delete
asked 2011-09-09T11:48:57.467
12
votes
2
answers

SSIS - Delete rows

ssis insert delete-row sql-delete
asked 2011-08-31T07:54:43.673
26
votes
5
answers

How can I insert the return of DELETE into INSERT in postgresql?

postgresql sql-insert sql-delete
asked 2011-07-05T03:55:09.687
75
votes
6
answers

MySQL LIMIT on DELETE statement

mysql limit sql-delete
asked 2011-05-24T14:25:28.203
9
votes
3
answers

MySQL: Why is DELETE more CPU intensive than INSERT?

mysql cpu-usage sql-insert sql-delete
asked 2011-02-17T20:00:22.823
109
votes
14
answers

How to delete/create databases in Neo4j?

database neo4j nodes sql-delete relationships
asked 2010-12-21T10:56:36.137
77
votes
6
answers

I got error "The DELETE statement conflicted with the REFERENCE constraint"

c# sql truncate sql-delete
asked 2010-09-23T07:42:08.447
12
votes
3
answers

MySQL, delete and index hint

mysql query-optimization sql-delete sql-execution-plan
asked 2010-05-27T20:33:14.250
238
votes
6
answers

Deleting rows with MySQL LEFT JOIN

mysql left-join delete-row sql-delete
asked 2010-05-04T06:20:32.377
26
votes
7
answers

Delete, Truncate or Drop to clean out a table in MySQL

mysql sql-delete sql-drop
asked 2010-04-08T16:16:03.220
77
votes
6
answers

How to get the number of deleted rows in PostgreSQL?

postgresql sql-delete delete-row rowcount
asked 2010-02-12T11:58:05.027
13
votes
4
answers

How do you enable LIMIT for DELETE in SQLite?

sqlite limit sql-delete
asked 2009-12-01T07:10:45.363
10
votes
4
answers

Python MySQL - SELECTs work but not DELETEs?

python mysql select sql-delete
asked 2009-09-20T19:22:23.413
117
votes
19
answers

Deleting millions of rows in MySQL

mysql query-optimization sql-delete
asked 2009-08-23T16:39:32.657
63
votes
14
answers

Faster way to delete matching rows?

mysql performance sql-delete sql-execution-plan
asked 2009-05-01T18:12:09.083
10
votes
4
answers

delete rows from multiple tables

mysql delete-row sql-delete
asked 2009-04-09T14:50:43.880
59
votes
8
answers

Counting the number of deleted rows in a SQL Server stored procedure

sql-server t-sql audit sql-delete
asked 2008-10-06T12:56:22.690
860
votes
18
answers

MySQL Error 1093 - Can't specify target table for update in FROM clause

mysql subquery sql-delete mysql-error-1093
asked 2008-09-05T10:03:46.590