sql-delete
Oracle performance - disabling FKs to make DELETE statement work faster?
When deleting from a large table in Oracle - let\'s call it table X - does it make sense to disable table X\'s FKs that do not have ON DELETE CASCADE?I\'m not referring to disabling FKs on other table[详细]
2023-03-05 14:31 分类:问答Deleting from multiple tables using gridview delete command
I have a grid view utilizing sql data source. Now I want to delete a record using grid view\'s delete command, the problem is that a single record is based on information collected from multiple table[详细]
2023-03-05 09:06 分类:问答Oracle delete row using sequence number
My DB knowledge is quite limited and I am trying to delete a row with the following query: DELETE FROM table[详细]
2023-03-04 22:24 分类:问答Delete multiple rows in MYSQL with info from python list
If list LL: LL = [\'foo\', bar\', \'noo\', \'boo\',] is in a MySQL table, test in column ID with other ID\'s.[详细]
2023-03-04 18:47 分类:问答SQL Delete Syntax Error, also some PHP and Jquery
I have a database table named \'favoritecats\' with the following fields: id catName catId I am using Jquery to run this function on click event of anelement on DOM Ready.[详细]
2023-03-03 22:45 分类:问答Two tables - how to delete rows if ID not referenced in both tables
I have two tables: listings(item_id, ...) images(item_id,...) The item_id value is the same in both tables - but I goofed and deleted listings from the \'listings\' table without also deleting the[详细]
2023-03-02 04:54 分类:问答Maximum values possible in a WHERE IN query
I have a table with over 3000000 entries, and i need to delete 500000 of them with given ID\'s. My idea is to create a query like:[详细]
2023-02-28 20:13 分类:问答What is wrong with my DELETE in SQL query?
My SQL query contai开发者_运维知识库ns an equation that doesn\'t function. Here is what it looks like:[详细]
2023-02-28 10:32 分类:问答Symfony Doctrine_Query DELETE with INNER JOIN
I am using symfony+doctrine, and I want to perform a delete query with a join. See below for my code I am currently using that works fine.[详细]
2023-02-28 07:04 分类:问答SQL delete records with same ID, leaving 1
Strange question, I know. I don\'t want to delete all the rows and start again, but we have a development database table where some of the rows have duplicate IDs, but different values.[详细]
2023-02-28 01:23 分类:问答