sql-delete
DELETE all where MySQL foreign key constraint does not fail
I am trying to delete a few records but am getting the following error: Cannot delete or update a parent row: a foreign key constraint fails[详细]
2023-03-26 07:52 分类:问答PHP unlink is asking for a string trying to give it sql string
I am trying to delete an item from a folder somewhere, and I need to pass in the path of the item to unlink(). For some reason it says I am not returning a string, which I am not sur开发者_C百科e how[详细]
2023-03-26 00:58 分类:问答SQL Delete Statement (Where <Field> Not In)
How 开发者_开发知识库can I delete a specific row on a table only if its data is not used by another table anymore?[详细]
2023-03-25 08:21 分类:问答Deleting from multiple tables with foreign constraints
I am trying to delete from multiple tables. Here\'s what my tables look like A_has_B ---- B ---- C_has_B[详细]
2023-03-23 19:13 分类:问答Using SQL to perform unique delete
I have a few tables in MySQL like so: A ---- A_has_B ---- B (many to many)| C ---- C_has_B------- (many to many)[详细]
2023-03-23 13:28 分类:问答Deleting Rows: No Single Member Has More Than x Records
I have a table structured like this: CREAT TABLE `member_logins` ( `id` bigint(10) unsigned not null auto_increment,[详细]
2023-03-22 17:21 分类:问答Delete query in mysql
I want to delete rows from multiple tables. I know the select query, but I need an exact delete query for all the columns that are defined below:[详细]
2023-03-22 16:40 分类:问答inserting and deleting not happening in local database (.sdf)
When I try to select values from a local database it executes without any issue. But when I try to insert and delete it\'s executing the query but it\'s not affecting any rows.[详细]
2023-03-21 21:40 分类:问答SQLite delete query in Android
I\'d need your help, I\'m starting with Android databases and I have a litte problem/question for update my tables (maybe is a stupid question but is hard for me ) :[详细]
2023-03-21 03:59 分类:问答Delete query error message:"specify the table containing records u want to delete"
Iwant to delete all records from table \"T\" if the records are also in table D, but I am getting the error message \"SPECIFY THE TABLE CONTAINING THE RECORDS YOU WANT TO DELETE\".[详细]
2023-03-20 19:57 分类:问答