0
answers
Delete sql rows where IDs do not have a match from another table
P粉763748806 2025-12-27 12:43:10
Views 61
0
I'm trying to delete orphan entries in a mysql table.
I have 2 tables like this:
Table files:
| id | .... |
|---|---|
| 1 | .... |
| 2 | .... |
| 7 | .... |
| 9 | .... |
table blob:
| fileid | .... |
|---|---|
| 1 | .... |
| 2 | .... |
| 3 | .... |
| 4 | .... |
| 4 | .... |
| 4 | .... |
| 9 | .... |
The fileid and id columns can be used to join the tables together.
I want to delete all rows in table blob where fileid cannot be found in the table files.id.
So using the example above that would delete rows: 3 & 4(s) in the blob table.
Your Answer
0 answers
Hot tools Tags
Hot Questions
The AsyncTask API is deprecated in Android 11. What are the alternatives?
2025-12-30 22:01:17
Determine if a type is an STL container at compile time
2025-12-30 21:43:19
Preserve Line Breaks From TextArea
2025-12-30 21:22:11
How to join two dataframes for which column values are within a certain range?
2025-12-30 21:01:08
How to import/include a CSS file using PHP code and not HTML code?
2025-12-30 20:43:33
Popular tool
vc9-vc14 (32+64 bit) runtime library collection (link below)
Download the collection of runtime libraries required for phpStudy installation
VC9 32-bit
VC9 32-bit phpstudy integrated installation environment runtime library
PHP programmer toolbox full version
Programmer Toolbox v1.0 PHP Integrated Environment
VC11 32-bit
VC11 32-bit phpstudy integrated installation environment runtime library
SublimeText3 Chinese version
Chinese version, very easy to use
Hot Topics
Douyin level price list 1-75
20416
7
20416
7
wifi shows no ip assigned
13574
4
13574
4